How do I specific digits in a long string?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column with a long number, similar to a VIN number on a car.
I need to be able to display only the 3rd and 4th digits, which represent
the year.
Example:

3692040105 (year is 1992)
3694789321 (year is 1994)
3795564113 (year is 1995)

I want this column to look like-
92
94
95

Is this possible? Is there a formula or a custom formating I can use?
 
You must log in or register to reply here.

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

Date Difference in Complete Tax Years 1
Date Formatting & Sorting 2
Date Reformating Question 2
How do I sort by the first digit of a number? 7
need a formula to find "*" in s string and multiply by preceding andfollowing values 5
Complete Tax Years 1
Extracting 7 digit number from alphanumeric string 10
Turning a 9 digit string into zip+4 3

Back
Top