 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
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.
TEXT
So using TEXT, what is the format_text to do the conversion of a number to a letter?
Ah, ok worked it out. CHAR() is where its at. Thanks Jam bo.
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 )
=CHAR(64+A1) where the number is in cell A1
There may be other ways
Too slow by 8 secs
Goes off to end it all
Ah yeah. Didn't read the requirement spec properly...