Link to home
Start Free TrialLog in
Avatar of bpatton_psr
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.
ASKER CERTIFIED SOLUTION
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bpatton_psr
bpatton_psr

ASKER

Excellent, thanks!!