| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
name sorting
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! -------------------- (Ms-Exl-Learner) -------------------- "Carl R" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
name sorting
Just format the cell as Text and try to enter the value
Select the range and do Right Click and select Format CellsNumberCategoryText and give ok. Otherwise before entering the value in a cell type ' and enter your Zero value numbers. If this post helps, Click Yes! -------------------- (MS-Exl-Learner) -------------------- "Carl R" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
name sorting
Please Ignore my previous post, By mistake i was posted it in your query....
-------------------- (Ms-Exl-Learner) -------------------- "Ms-Exl-Learner" wrote: Just format the cell as Text and try to enter the value Select the range and do Right Click and select Format CellsNumberCategoryText and give ok. Otherwise before entering the value in a cell type ' and enter your Zero value numbers. If this post helps, Click Yes! -------------------- (MS-Exl-Learner) -------------------- "Carl R" wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
name sorting
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. Ms-Exl-Learner wrote: 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! -------------------- (Ms-Exl-Learner) -------------------- "Carl R" wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Values Without Sorting Formulas | Excel Discussion (Misc queries) | |||
| Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
| Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
| Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
![Carl R[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
