bpatton_psr
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER