Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort Data Out of One Cell
I've been given a spread sheet that has the customer name and thier customer
number in the same cell. Is there a way that I can sort out the customer number to another cell so that a sort can be done by custome number. EXAMPLE:[ ACE HARDWARE 889425 ] (all in one cell) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort Data Out of One Cell
Check out TTC - Text To Columns - in the Help files.
That should be perfect for what you need. Post back with any questions. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "dbizek" wrote in message ... I've been given a spread sheet that has the customer name and thier customer number in the same cell. Is there a way that I can sort out the customer number to another cell so that a sort can be done by custome number. EXAMPLE:[ ACE HARDWARE 889425 ] (all in one cell) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort Data Out of One Cell
Hi
Is the Customer number always 6 digits? If so then =RIGHT(TRIM(A1),6) -- Regards Roger Govier "dbizek" wrote in message ... I've been given a spread sheet that has the customer name and thier customer number in the same cell. Is there a way that I can sort out the customer number to another cell so that a sort can be done by custome number. EXAMPLE:[ ACE HARDWARE 889425 ] (all in one cell) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort Data Out of One Cell
Yes they are all the same length. THANKS!
WORKS PERFECT! "Roger Govier" wrote: Hi Is the Customer number always 6 digits? If so then =RIGHT(TRIM(A1),6) -- Regards Roger Govier "dbizek" wrote in message ... I've been given a spread sheet that has the customer name and thier customer number in the same cell. Is there a way that I can sort out the customer number to another cell so that a sort can be done by custome number. EXAMPLE:[ ACE HARDWARE 889425 ] (all in one cell) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort Data Out of One Cell
See the reply after yours. It worked perfect.
Thanks! gDyer" wrote: Check out TTC - Text To Columns - in the Help files. That should be perfect for what you need. Post back with any questions. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "dbizek" wrote in message ... I've been given a spread sheet that has the customer name and thier customer number in the same cell. Is there a way that I can sort out the customer number to another cell so that a sort can be done by custome number. EXAMPLE:[ ACE HARDWARE 889425 ] (all in one cell) |
#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 |
Reply |
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 |