Changing the order of a name in various cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column with over 400 rows of names that most contain names reading last name first then a comma then a persons first name. Such as Sullivan, Mike. How can I change the order to read first name then last name without the comma? Such as Mike Sullivan.

Thank you for looking.
 
Hi

With entry in A1:
=RIGHT(A1,LEN(A1)-FIND(",",A1)-1) & " " & LEFT(A1,FIND(",",A1)-1)


--
Arvi Laanemets
(Don't use my reply address - it's spam-trap)


happydude said:
I have a column with over 400 rows of names that most contain names
Click to expand...
reading last name first then a comma then a persons first name. Such as
Sullivan, Mike. How can I change the order to read first name then last
name without the comma? Such as Mike Sullivan.
 
You must log in or register to reply here.

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

modifying name format within a cell 2
Can I switch the order of text entries in a cell? 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How do I convert last name, first name in cells to first name las. 4
reformat a cell from last name, first to first space last? 5
Windows 10 I would like to know in a batch file how to indentify computer name by using the first 5 of the name and the last 2 of the name then call runcmd 0
Change data in a single column from "last, first" to "first last" 3
Split Data in One Column Into Two 2

Back
Top