(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?
- braydenLv 710 years agoFavorite 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)