Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting part of a number in a cell
I have about 12,000 vin numbers in which I am constantly sorting through.....
What I need to do is find an equation that picks out one letter/number out of the Vin number and uses that selection to put in another column. Because each letter/number in the Vin represents something differently, I would like to find an equation that I could talor, depending on which letter/number in the Vin I'd like it to pull. example: Vin numbers 4SRTB6543890, 4VTR7543897, 4XTN7548900 I would like the equation to pull out any vin numbers that have the fifth item in the vin a "7" . ( which would indicate the year it was made- 2007)-- But expand this search for 12,000 vin numbers..... Thank you again all! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting part of a number in a cell
=IF(ISNUMBER(--MID(A1,5,1)),IF(--MID(A1,5,1)=7,A1,""),"")
or is you want to select the 5th digit by putting 5 in D1, and look for 7 by putting 7 in E1, then use something like =IF(ISNUMBER(--MID(A1,D$1,1)),IF(--MID(A1,D$1,1)=E$1,A1,""),"") -- David Biddulph "HRassist" wrote in message ... I have about 12,000 vin numbers in which I am constantly sorting through..... What I need to do is find an equation that picks out one letter/number out of the Vin number and uses that selection to put in another column. Because each letter/number in the Vin represents something differently, I would like to find an equation that I could talor, depending on which letter/number in the Vin I'd like it to pull. example: Vin numbers 4SRTB6543890, 4VTR7543897, 4XTN7548900 I would like the equation to pull out any vin numbers that have the fifth item in the vin a "7" . ( which would indicate the year it was made- 2007)-- But expand this search for 12,000 vin numbers..... Thank you again all! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Culling, Or Selecting, Part Of A Number In A Cell | New Users to Excel | |||
Selecting the first time a number appears (part 2) | Excel Discussion (Misc queries) | |||
Selecting part of a series for a chart? | Charts and Charting in Excel | |||
How to return a dollar value for a part number entered in a cell | Excel Worksheet Functions | |||
How do I format a cell for a custom part number? | Excel Discussion (Misc queries) |