Adapted from an earlier post
If you have your names+numbers in Col A and assuming a blank between last
letter and first number
then enter this in B1
=LEFT(A1,MIN(FIND({0;1;2;3;4;5;6;7;8;9},A1&"012345 6789"))-2)
and copy down
and this in C1
=RIGHT(A1,LEN(A1)+1-MIN(FIND({0;1;2;3;4;5;6;7;8;9},A1&"0123456789")))
and copy down

"SherryScrapDog" wrote:

I have a column with names and number(s) in them and want to end up with the
name in one column and the number(s) in another column. The first names may
actually be just one name or it could include middle and/or title. The
number may be 1 or more numbers (these are page number(s) for this name).
Here are a few examples:

S. J. 45, 46, 59, 71, 138, 139
S. J., Mrs. 138
Samuel J. 51
Sally 3
W. 41
Warren 17, 61, 71, 95, 109

I want 2 columns:
Name Page
S. J. 45, 46, 59, 71, 138, 139
Samuel J. 51
Sally 3
W. 41
Warren 17, 61 71, 95, 109

Can this be done?
thanks in advance if you can help, Sherry