suggestion

  • Thread starter Thread starter KU
  • Start date Start date
K

KU

I have numbers in a column and an example of the numbers in one cell
is 0 -000-2108-000
My problem is that I want to remove the first numbers, or hide them or
sort the cell such that 2108 is in front. The bottom line is that I
want to sort the column by the 2108 number and do it in an automated
way rather than going 640 cells down deleting the front numbers,
because I will also need them later. Any suggestions?
 
If your numbers will all be the same format (ie.- end with 4 digits a hyphen
and then 3 more digits), then one way would be to use a helper column:

=MID(A1,LEN(A1)-7,4)

Copy the formula down and sort on that column.

HTH,
Paul
 
Back
Top