How do you change the order of text in an Excel worksheet cell?

Question

I received an Excel spreadsheet where the names are listed FIRST LAST and I want them to be listed LAST, FIRST. Any way to do that without having to retype all the cells?

Answer 1

Here is the answer
If your cell of the first [FIRST LAST] name is in A1, then in B1, paste this
=MID( A1, SEARCH(" ", A1)+1, 500)&" "&LEFT(A1, SEARCH(" ", A1))
then copy and paste this function to the B cells below, and here we go

I told you , I am the VBAXLMan

Answer 2

Please put extra info.

is the first and last name typed in the same cell? If it is, you can't, if it isn't, then click the column name (letter) you want to be first, press CTRL and "X" at the same time, that will cut the column, then move the other column by draging, to the space you want it in, and then past the column you cut into the toher palce...srry if i dont make sense its not too easy to exp,ain lol...

Answer 3

My way is better to be safe than sorry --

Open the Excel file
Click the alphabet letter above FIRST
- the column should be selected and highlighted
click Insert, Column
- you should get a new column to the left of FIRST
click the alpha letter above LAST, right-click and COPY
click the alpha letter above the blank column, PASTE
if the paste was successful, select the original LAST, right-click and delete.

Answer 4

If the above formula does not work for you, you may have to go in and highlight the last, use Ctrl-X to cut it, move to the front of the first name and paste it with Ctrl-V. Do this for each cell.

Answer 5

do you really want to do that cause i dont think you really do