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

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.
 
J

Jacob Skaria

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)
 
Top