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?


--
kaustubhghag
------------------------------------------------------------------------
kaustubhghag's Profile: http://www.excelforum.com/member.php...o&userid=32772
View this thread: http://www.excelforum.com/showthread...hreadid=562028