Forum Discussion
Months to letters of the alphabet
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... ...
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))
- 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!!!!The explicit assumption in my reply was that D2 contained a date...
Glad you got it working.
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!
