Thread: How to separate id and name from column
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default How to separate id and name from column
For data in A1 and assuming blank as a separator:

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

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

HTH

"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?


--
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