Excel formula assistance - Need to split data in cells

I have a column with the following info:

WASHINGTON, GEORGE M 034562           55195929
OBAMA, BARACK H 073476           55195937
BUSH, GEORGE 290334           55195945
KENNEDY, JOHN F 289573           55195952
NIXON, ROBERT 295735           55195960
DOE, JOHN O 234540          55195978
PACINO, AL BUNDY 176439           55195906
STARK IV, TONY W 067600           55195994
CAPONE, AL 024325           5519600D
and so on...

As you can see some of the names have commas, some have initials, some have periods INSTEAD of commas. All I need is a formula that can extract in COLUMN B, just the name WITHOUT the numbers at the end. So my result in COLUMN B should look like:

WASHINGTON, GEORGE M
OBAMA, BARACK H
BUSH, GEORGE
KENNEDY, JOHN F
NIXON, ROBERT
DOE, JOHN O
PACINO, AL BUNDY
STARK IV, TONY W
CAPONE, AL

Thanks so much, in advance!

-JJr.
bpatton_psrAsked:
Who is Participating?
 
barry houdiniCommented:
You could extract everything before the first digit, i.e. in B2

=TRIM(LEFT(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&1234567890))-1))

regards, barry
0
 
McOzCommented:
It looks as if there are the same number of "number characters" after each name - if this is the case throughout, you could get by it simply by putting this formula in column B:

=TRIM(SUBSTITUTE(A1,RIGHT(A1,25),""))

Cheers
0
 
bpatton_psrAuthor Commented:
Excellent, thanks!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.