Forum Discussion
Solved
Converting date into letters
I receive orders from my customers off of blanket orders. To differentiate releases off of these blanket orders I tag these orders with a short, intuitive alphanumeric code added to the blanket numbe...
Jim_T_0228 CHR should have been CHAR and did you replace the "d" with the cell reference? see attached example
Oh-boy... help me unpack THAT one... My version of Excel doesn't have a CHR or LAMBDA function. There is a CHAR function, but when I append everything else you note below (with spaces and ampersands) it gives me a name error.
What am I doing wrong, or rather is there another way you can think of?
Jim_T_0228 CHR should have been CHAR and did you replace the "d" with the cell reference? see attached example
- GENIUS. Thank you!