Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting a concatenated cell
I have a cell that is entered FIRSTNAME, LAST NAME. What I have done is using TRIM LEFT MID and Finally Concatenate, switched the First name with the last name in a different column. Now all I want to be able to do is to sort the cells alphabetically. I am sure that I need to use another approach to this. -- wmack ------------------------------------------------------------------------ wmack's Profile: http://www.excelforum.com/member.php...o&userid=37801 View this thread: http://www.excelforum.com/showthread...hreadid=573649 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting a concatenated cell
It seems to me that you should have sorted the data before concatenating them! -- raypayette ------------------------------------------------------------------------ raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569 View this thread: http://www.excelforum.com/showthread...hreadid=573649 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting a concatenated cell
well I can sort the data by the first name, but i want to sort it by the last name. I have 3 years worth of data, so just changing the entry method in not an option. Sorting a list of Dr's by first name is only so useful.... -- wmack ------------------------------------------------------------------------ wmack's Profile: http://www.excelforum.com/member.php...o&userid=37801 View this thread: http://www.excelforum.com/showthread...hreadid=573649 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting a concatenated cell
Use =Trim(), =Left(), and =Mid() to separate the names into parts once more.
But this time, don't delete those pieces. Just hide the columns if you want. Then you can sort by each piece. In fact, you can use a formula to concatenate the pieces into the full name. But I'd do the data entry using those idividual fields. wmack wrote: I have a cell that is entered FIRSTNAME, LAST NAME. What I have done is using TRIM LEFT MID and Finally Concatenate, switched the First name with the last name in a different column. Now all I want to be able to do is to sort the cells alphabetically. I am sure that I need to use another approach to this. -- wmack ------------------------------------------------------------------------ wmack's Profile: http://www.excelforum.com/member.php...o&userid=37801 View this thread: http://www.excelforum.com/showthread...hreadid=573649 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting data in a cell alphabetically | Excel Worksheet Functions | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
sorting, borders going with cell content | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions |