Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort / Filter in excel
I have a row of data that has strings of numbers / characters. Is there a way
to sort of the charaters whether they are at the beginning or end? Example: P224 24P 26A 28376A A20958 I would like to sort by the Charater - when it either at the begining of the string or end. Thanks, Kelly |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort / Filter in excel
You'll need a 'helper' column.
Let's assume your data is in Column A starting in cell A1. In cell B1 put the following formula and then copy it down. =IF(CODE(LEFT(A1,1))CODE(RIGHT(A1,1)),LEFT(A1,1), RIGHT(A1,1)) Sort on Column B. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "goonie" wrote: I have a row of data that has strings of numbers / characters. Is there a way to sort of the charaters whether they are at the beginning or end? Example: P224 24P 26A 28376A A20958 I would like to sort by the Charater - when it either at the begining of the string or end. Thanks, Kelly |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort / Filter in excel
Worked Great - Thank You
"Gary Brown" wrote: You'll need a 'helper' column. Let's assume your data is in Column A starting in cell A1. In cell B1 put the following formula and then copy it down. =IF(CODE(LEFT(A1,1))CODE(RIGHT(A1,1)),LEFT(A1,1), RIGHT(A1,1)) Sort on Column B. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "goonie" wrote: I have a row of data that has strings of numbers / characters. Is there a way to sort of the charaters whether they are at the beginning or end? Example: P224 24P 26A 28376A A20958 I would like to sort by the Charater - when it either at the begining of the string or end. Thanks, Kelly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Pivot Table - Sort Report Filter Values | Excel Discussion (Misc queries) | |||
Excel 07 Sort & Filter A to Z | Excel Discussion (Misc queries) | |||
Excel changes formula after data sort/filter, please help. | Excel Discussion (Misc queries) | |||
Excel 2007 can not filter / sort in sheet with 657,000 rows | Excel Discussion (Misc queries) | |||
Excel 2007 data corruption using sort within a filter. | Excel Discussion (Misc queries) |