Sorting question

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

I need to sort a worksheet by a column with values like

LX5-C1001
LX5-C1002
LX5-C0003
LX5-C0004
LX5-C2005
LX5-C1006

etc. I need to ignore everything except the last three digits. How
do I do this?

Ed
 
You will need a helper column. If the real data is in A1, use =RIGHT(A1,3)
in the helper column and copy down the column.
Sort the block of data.
best wishes
 

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

VLOOKUP...help please! 4
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Sort Cells/Columns 6
Question on Sorting by (date, etc) 5
tricky sorting question 3
Excel 2007 Sort-How to Retain Sort Order 3
modifying data in a field 2
Problem sorting a range of columns using VBA 1

Back
Top