Thread: name sorting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carl R[_2_] Carl R[_2_] is offline
external usenet poster
 
Posts: 15
Default name sorting

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