| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting item numbers
I need to sort a column of items by the last letter in the item number:
BA101A BA102C ST101A How can I do this? Do I need to split the cell and then sort it? If so how do I do that? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Splitting item numbers
Insert a helper column to the right of your data and parse off the last
character of the item number. So if the item number is in column C starting at row 2, enter the formula: =RIGHT(C2,1) Copy it down the column and use this as the sort column -- Kevin Backmann "Spencer" wrote: I need to sort a column of items by the last letter in the item number: BA101A BA102C ST101A How can I do this? Do I need to split the cell and then sort it? If so how do I do that? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Splitting item numbers
"Spencer" wrote in message
... I need to sort a column of items by the last letter in the item number: BA101A BA102C ST101A How can I do this? Do I need to split the cell and then sort it? If so how do I do that? If you use a helper column =RIGHT(A1) you can sort by that. -- David Biddulph |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Splitting item numbers
You can get the last character by using a blank column and entering
this formula: =RIGHT(A1,1) assuming your data is in A1. Copy this formula down the column. Include this column in your sort area and use this column as the key field to sort on (plus the other field). Hope this helps. Pete Spencer wrote: I need to sort a column of items by the last letter in the item number: BA101A BA102C ST101A How can I do this? Do I need to split the cell and then sort it? If so how do I do that? Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Splitting item numbers
In an adjacent column, add
=RIGHT(A1,1) copy down, and sort by that column -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Spencer" wrote in message ... I need to sort a column of items by the last letter in the item number: BA101A BA102C ST101A How can I do this? Do I need to split the cell and then sort it? If so how do I do that? Thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Splitting item numbers
One way would be to use a helper column. For example, in the cell next to
BA101A, use the following formula to determine the last letter. =right(A1,1) Copy this formula down as needed. Then you can sort by this column. HTH, Paul "Spencer" wrote in message ... I need to sort a column of items by the last letter in the item number: BA101A BA102C ST101A How can I do this? Do I need to split the cell and then sort it? If so how do I do that? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting Numbers Into Different Columns | Excel Discussion (Misc queries) | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Need to sum up numerous columns in different worksheet into 1 | New Users to Excel | |||
| Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
Linear Mode
