“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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