Good morning everyone.
I'm using Excel 2010.
In a series of cells, all contained in a single column, I have some values that end with a numeric string. In practice, the value in the cell represent the name and surname of many employees, followed by an alphanumeric string that represents the employee ID number and consists of:
space
-
space
numeric string of variable length.
Some cells are deprived of the numeric string. The full name and surname of the employee is of variable length.
For example (these names are obviously fictitious):
Robert Callaghan - 2246
Alan Cornwall
Elizabeth McCormick Addams - 1522
I have to extract only the text string that is placed before the numeric characters and the character "-".
I tried with the division of the text into columns, but as the name is of variable length I can't determine where I have to place the delimiter.
Could anyone help me?
Thanks in advance.
Bookmarks