If you have fix number of digits of ID say four as you mentioned (i-e
1111) then use the following formula, suppose your data is in cell A1
=MID(A1,1,4) this will extract ID from combined ID&Name
To extract name use:
=MID(A1,4,100)
kaustubhghag Wrote:
Hello
I have one excel sheet in which id and name is shown combined. So i
want to show id on different column and name on different.
So is there any way/ formula in excel sheet to differ it?
Example:
Employee name DateIn TimeIn DateOut Timeout
1111 Kaustubh 4-Apr06 1:00 4-Apr06 2:00
So i want to show 1111 on different column. So is there any formula for
extraction of this?
Please mail me solution on
--
starguy
------------------------------------------------------------------------
starguy's Profile:
http://www.excelforum.com/member.php...o&userid=32434
View this thread:
http://www.excelforum.com/showthread...hreadid=562028