 # 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!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## 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