LewisReeder
IS-IT--Management
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
Thanks,
Lewis