name listings

  • Thread starter Thread starter hugoalegria
  • Start date Start date
H

hugoalegria

I have several name lists in which each of the names are entered in single
cells
as first name last name, is there a formula to reverse the order? Example'
Jane Doe changed to Doe Jane within the same cell.
 
Not within the same cell, but if you could use a helper column of cells, you
could use a formula like:

With the name in A1, you could use this in B1:
=MID(A1,SEARCH(" ",A1)+1,LEN(A1))&" "&LEFT(A1,SEARCH(" ",A1)-1)
 

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

Can I switch the order of text entries in a cell? 3
Invert Cell contents 3
looking for help again 1
vlookup using match and date range 1
alpha numeric sorting 2
Formula to change Name format 2
Bringing to a cell the last date an event occurred 6
SUMIF & IF 5

Back
Top