Thread: How to separate id and name from column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kaustubhghag kaustubhghag is offline
external usenet poster
  
Posts: 1
Default How to separate id and name from column

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

Reply With QuoteReply With Quote