| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort Data Out of One Cell
Choose Data Tab then "text to columns" then "deliminited" click next then chose "space" click finish that will seperate each word into it's own column then you should be able to do any type of sorting from there -- mikecookaxa ------------------------------------------------------------------------ mikecookaxa's Profile: http://www.excelforum.com/member.php...o&userid=27926 View this thread: http://www.excelforum.com/showthread...hreadid=500291 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| I want to sort Data A-Z starting at Cell A1 to C34 | Excel Discussion (Misc queries) | |||
| data sort by highlighted or coloured cell | Excel Worksheet Functions | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Threaded Mode
