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...
With a name in B2:
=LET(chars, MID(UPPER(B2), SEQUENCE(LEN(B2)), 1),
letters, FILTER(chars,(chars>"A")*(chars<="Z")),
codes, CODE(letters)-64,
TEXTJOIN(" ", TRUE, codes))Fill down.
HansVogelaar Thank you very much!! This worked perfectly!