Sorting

S

sdmccabe

I would like to sort a column of alpha-numeric characters by only the last
seven characters – can someone help? Thanks.
 
C

Chip Pearson

Insert a new column next to your data, enter the formula
=RIGHT(A1,7), copy down as far as you need to go, and sort on
that column.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
S

sdmccabe

I am missing something, sorry. I data I want to limit to seven characters
starts in column G2. In H2 I entered the formula, =right(h2,7), but it
doesn't display the last seven - what did I do wrong?
 
S

sdmccabe

I meant to say =right(g2,7)

sdmccabe said:
I am missing something, sorry. I data I want to limit to seven characters
starts in column G2. In H2 I entered the formula, =right(h2,7), but it
doesn't display the last seven - what did I do wrong?
Click to expand...
 
P

Pete_UK

We seem to have cross-posting here. I suggested in the other thread
that you should ensure H2 is not formatted as text - click H2, Format |
Cells | Number (tab) then select General. Then double click the cell as
if to edit and press <enter> - you should see the final 7 digits. Then
copy down and sort.

Hope this helps.

Pete
 
Top