Get instant live expert help on convert letters to numbers
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need a formula to convert a string of letters within a cell to numbers - abcdef to 123456
Solved by B. A. in 28 mins
I need to convert a string of letters, example "NEEGVQE" which all in one cell and convert each letter into a number, example
N= -3.5
E= -3.5
G= -0.4
V= 4.2
Q= -3.5
and then add those numbers up to get a value.
Solved by V. U. in 25 mins
I have a row of letters and numbers i need to remove the letters and add them to another column. Example BSN17525
Solved by V. Q. in 28 mins
i want to get rid of letters from a combination of numbers and letters and but values with a specific letter i want to be negative and the rest positive
Solved by B. J. in 22 mins
Hello, I need check the format of a cell I need it to return the following logic:
IF the first two letters in column E = GB AND has 9 numbers are the two letters then that should return correct.
OR
IF the first two letters in column E = FR AND has 11 numbers are the two letters then that should return correct.
OR
IF the first two letters in column E = DE AND has 9 numbers are the two letters then that should return correct.
SO the the logic is IF left and len is number.
Solved by T. J. in 30 mins