Split cell text with variable spaces

I have a column of cells and each cell follows the following format: <number><dash><name>

For example: 2-Henry, and 7-Elizabeth

I need to extract just the name and not the number or dash - the problem is that the original author occasionally placed a space either after, before or both after & before the dash, so some entries look like: 4- Tom or 6 -Bob, or even 8 - Mary.

Is there a way to extract just the name when the range of cells are not uniform in the spacing?

Not more than one name, but of course the name lengths vary in character length. Too much sanitizing to post the workbook, but if needed, I could write a sample and post it, though it would pretty much be the text samples in my original post copied to a column of cells...

Originally Posted by FDibbins

If ... the numbers are only 1 character

The numbers repeat at uneven intervals but are sequential, so I have four number 1's, the and three number 2's, five number 3's, etc... but then they do reach double digits, for example, 10- <space> Adam, and 11-Carrie (no spaces), and 11 -Garrett.

But I think I can use your formula and change it at the point where the double digits begin (it doesn't grow to triple digits)... how would the formula look to handle double digits?

Originally Posted by Ron Coderre

OK
with these values in A1:A5
2-Henry
4- Tom
6 -Bob
8 - Mary
7-Elizabeth

This formula, copied down, extracts the name after the dash

Please Login or Register  to view this content.

for those values, these are the results:
Henry
Tom
Bob
Mary
Elizabeth

Is that something you can work with?

Sorry didn't see this before FDibbins' reply - I'll give it a try!

Both Ron's and Alkey's (which were variations on the same principle) worked. Thanks guys!!!

-HeyInKy

Yes - but thanks FDibbins - you've *always* been helpful!!