How do I get the last 7 characters of a no. to another column?

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

I need to get the last 7 characters of a number in one column to another
column so I can sort them. The number is in the format 00-1234-12.
 
Hope your data is in text format and not formatted to display as 00-0000-00
format. If you mean to extract 1234-12 from 00-1234-12; try..

=RIGHT(A1,7)
 
Back
Top