Help splitting text entries with commas
 

Hi all -

I have a sheet of names in the format "-Last name, First name, team-",
and I want to change the list to be "First name last name (no comma, no
team)". I can't think of a simple way to do it? Is there a way to
split text using a specific symbol (comma in this case) as the divider?
I've been trying combos of "mid" with the "search" function to find the
first comma. This has allowed me to extract the last name, but I'm
having trouble getting the isolated first name...

Thanks!


--
andrewm27
------------------------------------------------------------------------
andrewm27's Profile: http://www.excelforum.com/member.php...o&userid=25130
View this thread: http://www.excelforum.com/showthread...hreadid=535322

Help splitting text entries with commas
 

Hi

Use 'Text to Columns' feature from Data menu

Arvi Laanemets


"andrewm27" wrote
in message ...

Hi all -

I have a sheet of names in the format "-Last name, First name, team-",
and I want to change the list to be "First name last name (no comma, no
team)". I can't think of a simple way to do it? Is there a way to
split text using a specific symbol (comma in this case) as the divider?
I've been trying combos of "mid" with the "search" function to find the
first comma. This has allowed me to extract the last name, but I'm
having trouble getting the isolated first name...

Thanks!


--
andrewm27
------------------------------------------------------------------------
andrewm27's Profile:
http://www.excelforum.com/member.php...o&userid=25130
View this thread: http://www.excelforum.com/showthread...hreadid=535322