Topic starter
Anyone know how I can convert numbers to text? I'm after just converting cells containing number 0 to 25, in the letter a to z. I had assumed there would be a function called DEC2ASCII or similar, but can't find it.
cheers in advance.
Posted : 09/06/2016 5:28 pm
TEXT
Posted : 09/06/2016 5:30 pm
Topic starter
So using TEXT, what is the format_text to do the conversion of a number to a letter?
Posted : 09/06/2016 5:46 pm
Topic starter
Ah, ok worked it out. CHAR() is where its at. Thanks Jam bo.
Posted : 09/06/2016 5:48 pm
to get the numbers to appear as letters you can probably use the 'char' function.
for 0 to be lowercase a then you should be able to use
=char( number + 97 )
Posted : 09/06/2016 5:49 pm
=CHAR(64+A1) where the number is in cell A1
There may be other ways
Posted : 09/06/2016 5:49 pm
Too slow by 8 secs
Goes off to end it all
Posted : 09/06/2016 5:49 pm
Ah yeah. Didn't read the requirement spec properly...
Posted : 09/06/2016 6:10 pm