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?