How to separate id and name from column
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?
|