Forum Discussion
letters into numerical equivalents?
Hello, I am very new to Excel and can't seem to find an accurate answer. I aim to convert a string of text in one column into a string of number (A=1, B=2, etc) in a different column. We are loo...
Another encoding that you could use for names of up to ten characters is
= DECIMAL(names,36)The limitation comes about because of the precision to which numbers are held in Excel. To restore the name you would then use the BASE function
= BASE(ID,36)
- Thank you Peter!
