Sorting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to sort a column of alpha-numeric characters by only the last
seven characters – can someone help? Thanks.
 
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
 
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?
 
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...
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with sorting numbers with text suffix 2
Sort Criteria 1
change rows and colums to display alpha instead of numerics 1
Sorting number combinations 9
LIMITING DATA VALIDATION ENTRIES 1
Data sort 1
Sorting Alphanumeric data 6
Prevent alpha character in numeric cell 2

Back
Top