Splitting item numbers

Splitting item numbers

Post by U3BlbmNlc » Fri, 13 Oct 2006 03:25:01


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
 
 
 

Splitting item numbers

Post by S2V2aW4gQ » Fri, 13 Oct 2006 03:31:03

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

 
 
 

Splitting item numbers

Post by David Bidd » Fri, 13 Oct 2006 03:32:12


If you use a helper column =RIGHT(A1) you can sort by that.
--
David Biddulph
 
 
 

Splitting item numbers

Post by Pete_U » Fri, 13 Oct 2006 03:33:34

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
 
 
 

Splitting item numbers

Post by Bob Philli » Fri, 13 Oct 2006 03:34:34

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)
 
 
 

Splitting item numbers

Post by PCLIV » Fri, 13 Oct 2006 03:35:47

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