name sorting

  • Thread starter Thread starter Carl R
  • Start date Start date
C

Carl R

I created a worksheet. In Colum A is the name colum, example I typed John Doe
in A1, is there a funtion that will enter his name as Doe John? I eneterd the
next name Dick Clark is there a function that will Automatically alphabetize
so it would go up to A1 or do you just have to click on the sort button?
looks like this
John Doe
Dick Clark

want it to look like this
Clark Dick
Doe John
--
Microsoft Office 2003 Version
Students and Teachers Edition
Windows Vista Home Premium

Thank-you
Carl R
 
Try this...

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

Change the cell reference A1 to your desired cell.

If this Post Helps, Click Yes!
 
Just format the cell as Text and try to enter the value

Select the range and do Right Click and select Format
Cells>>Number>>Category>>Text and give ok.

Otherwise before entering the value in a cell type ' and enter your Zero
value numbers.

If this post helps, Click Yes!
 
Just to add to Ms-Exl_Learner's response.

There was an unfortunate line break in the formula:

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

If you put this formula in B1, then it will reverse the 2 piece name in A1.
Then you can drag this formula down column B as far as your data goes in column
A.

But then you'll still have to select columns A and B and sort that data using
column B as the primary key.
 
Back
Top