Help splitting text entries with commas

A

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

splitting Last Name, First Name 4
modifying name format within a cell 2
Multiple Commas 3
Can I switch the order of text entries in a cell? 3
Change data in a single column from "last, first" to "first last" 3
Find function returns the #VALUE! error value 2
How to remove first comma in a value 8
Splitting text strings along commas. 3

Top