| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Thanks, Dave! :-)
Pete "Dave Peterson" wrote: Try copying from the newsgroup post, but paste it into the formula bar--not directly into the cell. =RIGHT(A1,LEN(A1)-FIND("^^",SUBSTITUTE(A1," ", "^^",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))) (I broke the line feed at a position that won't hurt when you copy|paste.) Peter Rooney wrote: Bob, Having a bit of trouble with this - it pastes into Excel in two cells and when I try to concatenate them, I keep getting #VALUE! I've looked repeatedly at what I have, but can't seem to find the error! Pete "Bob Phillips" wrote: I assume you have names such as Amanda Bainbridge in one cell. You need to extract the surname to sort on. In a helper column add this formula =RIGHT(A1,LEN(A1)-FIND("^^",SUBSTITUTE(A1," ","^^",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))) copy this for all names then sort all columns using this helper column as the key. -- HTH RP (remove nothere from the email address if mailing direct) "Amanda Bainbridge" <Amanda wrote in message ... How do I make surnames appear alphabetically in Excel spreadsheets? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort alphabetically by last letter in Excel? | Excel Discussion (Misc queries) | |||
| i want to list all my cd's alphabetically | New Users to Excel | |||
| sort by alphabetically | New Users to Excel | |||
| sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
| How do I arrange entries in a column alphabetically | Excel Discussion (Misc queries) | |||
Hybrid Mode
