in excel entry reported in c2 - 50216 is to be converted to 5021 in d2
and in the same way c3 - 45213 to 4521 in d3
2006-11-12 05:23:11 · 4 answers · asked by vemula p 1 in Computers & Internet ➔ Programming & Design
d2 - =int(c2/10)
easy
2006-11-12 05:29:42 · answer #1 · answered by orlandobillybob 6 · 0⤊ 0⤋
Learn Programming
goto
http://www.braindumpindia.com
2006-11-12 06:06:07 · answer #2 · answered by Neha S 1 · 0⤊ 0⤋
simply put the following formulas in cell d2 and d3 respectively
=int(c2/10)
=int(c3/10)
and it will work
2006-11-12 06:44:26 · answer #3 · answered by sheikh azad 1 · 0⤊ 0⤋
Dear Mr. X.
The question was pretty interesting.
Here is ur solution
*******************************************************
Assuming character length to be 5, Paste this in D2 and D3
=LEFT(C2,4)
=LEFT(C3,4)
*******************************************************
Still not satisified with the answer. email me........srisridhar3@yahoo.co.in.
2006-11-13 04:08:58 · answer #4 · answered by srisridhar3 2 · 0⤊ 0⤋