Here are some problems that our users have asked and received explanations on
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 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 tried to convert a value into date but excel gave me a unique string referencing months and years instead.
Solved by V. B. in 19 mins
formula to lookup multiple fields with multiple matches. convert index match formula to potential vba code
Solved by C. L. in 12 mins
What formula do I use to look into the contents of a cell for a specific string of characters, and count the number of cells that have that string?