ExcelBanter - How do I specific digits in a long string?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I specific digits in a long string? (https://www.excelbanter.com/excel-discussion-misc-queries/14211-how-do-i-specific-digits-long-string.html)

PhilGTI

How do I specific digits in a long string?

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?

Marvin P. Winterbottom

=mid(a1,3,2) will pick out those 2 characters

"PhilGTI" wrote:

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?

PhilGTI

Thanks Marvin!

"Marvin P. Winterbottom" wrote:

=mid(a1,3,2) will pick out those 2 characters

"PhilGTI" wrote:

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?

All times are GMT +1. The time now is 02:57 PM.