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)
 

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

Count entries in the column translating to minutes. 5
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Last number in a column shows in the total/summay line cell 3
Look up a text value then count records < a date 3
How to count the maximum number flanked by zeros 9
Lower-Case Characters 2
FIND text within text then sum 4
Excel Removing the last 7 characters of cell in excel 0

Top