How to separate id and name from column

[kaustubhghag]

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?

 

[Bob Phillips]

=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" <[email protected]>
wrote in message
news:[email protected]...

 

[starguy]

If you have fix number of digits of ID say four as you mentioned (i-
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)

 

[vezerid]

Hi,

Assuming the code contains no spaces and aftger the first space starts
the name.

For the code:
=LEFT(A2,FIND(" ",A2)-1)
For the name:
=MID(A2,FIND(" ",A2)+1,LEN(A2))

HTH
Kostis Vezerides

 

[Toppers]

For data in A1 and assuming blank as a separator:

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

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

HTH

 

[JE McGimpsey]

Instead of a formula, insert a column between Employee Name and DateIn,
select your Employee name column, and choose Data/Text to Columns.
Assuming all of your employee id's are the same length, choose Fixed
Width...


kaustubhghag