| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
=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? |
|
#3
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format cells to a specific number of digits? | Excel Discussion (Misc queries) | |||
| Excel Database Query String Too Long | Excel Discussion (Misc queries) | |||
| Find nth instance of a character in a string | Excel Discussion (Misc queries) | |||
| Transposing a Long String | Excel Worksheet Functions | |||
| Decimal to Binary | Excel Worksheet Functions | |||
Linear Mode
