TitoBurrito
New Member
- Joined
- Oct 27, 2022
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
So say I have a serial number in Cell A1 "22AA123456" I need 3 different formulas for three different cells.
Cell B1: This is grabbing the year. so the first 2 digits of the serial number would be the year. so 22 would be "2022" and that's what I need in B1.
Cell C1: This is grabbing the Month. (EX: A=January, B=Feb etc...) so the formula would see the 3rd index in the serial number string, so A, and spit out "January" in Cell C1.
Cell D1: This is grabbing the Location. (EX: A=America, M=Mexico) so the formula would see the 4th index as A and spit out "America" in Cell D1.
I'm having trouble telling it to look at like a specific index in the serial number. instead of saying like oh this cell contains the letter A so this is true, which don't work because the Month and Location have the same letters.
Cell B1: This is grabbing the year. so the first 2 digits of the serial number would be the year. so 22 would be "2022" and that's what I need in B1.
Cell C1: This is grabbing the Month. (EX: A=January, B=Feb etc...) so the formula would see the 3rd index in the serial number string, so A, and spit out "January" in Cell C1.
Cell D1: This is grabbing the Location. (EX: A=America, M=Mexico) so the formula would see the 4th index as A and spit out "America" in Cell D1.
I'm having trouble telling it to look at like a specific index in the serial number. instead of saying like oh this cell contains the letter A so this is true, which don't work because the Month and Location have the same letters.