=LEFT(A1,FIND(" ",A1)-1

=RIGHT(A1,LEN(A1)-FIND(" ",A1))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"kaustubhghag"
wrote in message
news:kaustubhghag.2b3car_1153141808.9665@excelforu m-nospam.com...

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