Cell splitting 1

[LewisReeder]

I currently have an excel file with thousands of employees and their employee numbers, both in one cell. Formatted as such, John Doe - 12345. I need to create a new cell for the employee number for the database I am creating. I know their is a way to extract just the number rather than copy and paste each number in a new cell. Is their a way to search the string and extract anything after the - ? Could someone please help.

Thanks,
Lewis

 

[walla07]

Hi Lewis,

If you highlight the whole range then use the 'Data' - 'Text to columns' wizard. Set the option to Delimited and check 'Other' in the next step and use - to separate the field.

Another option, if all the employee numbers are the same length, would be to use the formula "=right(A1,5)".