Months to letters of the alphabet

Copper Contributor

Hello everyone, I'm hoping someone knows this. 

I have to combine 4 columns to make a unique tracking number for each order shipped. 
This has to consist of "MONTH+YEAR+PO+16", the only deal is... Month is represented by the letters of the alphabet. so... this.... FlexAB55_0-1677588907293.png will end up this: FlexAB55_1-1677588932851.png.

 

How do I get excel to make If Month=January, then show "A" and so on for the whole year. 

 

Thank you! Hope you all have some tricks up your sleeves!

@EXCELR @Excel  (I had to tag people to post this... sorry to bother :() 

 

4 Replies

@FlexAB55 

Do you have the relevant date in a cell? Let's say it is in D1.

To return the letter, use the formula

 

=CHAR(64+MONTH(D1))

@Hans Vogelaar 

I do, it's in D2..however that's not working. 
If I put numbers there, it returns the letter "A" no matter what number is input. but if I put the months (with words), it errors for #Value!

FlexAB55_0-1677593536004.png

 

I managed top get to to work... well sort of.
=CHAR(64+(D2)) will get me what I want, but the moth has to be in number format, cannot have the words.
so if I did 3 instead of march, it worked.

Thank you!!!!

@FlexAB55 

The explicit assumption in my reply was that D2 contained a date...

Glad you got it working.