(mic. excel)i was making a class record w/ names on it, so you are supposed to write surname then firstname...?

I accidentally wrote firstname then surname, Is there any way to reverse the words with retyping it all?

1 Answer

Relevance
  • 10 years ago
    Favorite Answer

    This assumes A1 is where the name is. So if your names are like this: Jane Doe and you want it to be Doe, Jane then use this formula. Adjust it to your needs and copy it down to all of the rows. Just copy this formula I've typed for you below (into a cell near the names). Don't try to type it yourself from looking at this one or you might make a mistake in a space or comma, etc. After you get the names like you want, you could hide the column where the names currently are so that you don't see them anymore.

    =MID(A1,FIND(" ",A1)+1,LEN(A1))&","&" "&LEFT(A1,FIND(" ",A1)-1)

    • Login to reply the answers
Still have questions? Get your answers by asking now.