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

=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

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

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?

Please mail me solution on


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

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

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

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


In article ,
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?