Help splitting text entries with commas

[andrewm27]

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!

[Arvi Laanemets]

Hi

Use 'Text to Columns' feature from Data menu

Arvi Laanemets


"andrewm27" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>