Excel seperate first & last name

fuzool789

New member
Joined
Jan 20, 2013
Messages
1
Reaction score
0
Points
0
Hello,

I have an Excel assignment about seperating First & Last names in a given sheet. The sheet contains names as follows:
Forlani, Claire
Trejo, Danny
Prinze, Freddie Jr.
Mulroney, Dermot
Charles, Josh (SWAT)
Charles, Josh (SWAT)
Blair, Selma
Super Troopers
Broken Arrow (John Travolta / Christian Slater)
Goodfellas (Ray Liotta / Lorraine Bracco)

I am looking for a formula that will make the above names to:
Claire Forlani
Danny Trejo
Freddie Jr. Prinze
Dermot Mulroney
Josh Charles (SWAT)
Super Troopers
Broken Arrow (John Travolta / Christian Slater)
Goodfellas (Ray Liotta / Lorraine Bracco)

The only catch is Charles, Josh (SWAT) and I only want it to read Josh Charles (SWAT). The last three will remain the same.
Let me know if someone can write a formula for this ?
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,519
Reaction score
4
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
So it's an assignment? How about this... tell us what you've tried (show us your formulas) and what the results were. We'll help you tweak it to work. I'd rather help you learn than do it for you.
 
Top