Get instant live expert help on convert cell to string
“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
Search thru Column H and Column I, and IF the cell CONTAINs STRING A, STRING B, OR STRING C, return VALUE 1 OR if cell CONTAINs String D, String E, OR STRING F, return VALUE 2, OR if cell CONTAINs String G, OR String H, return VALUE 3 Otherwise, return UNKNOWN.
Solved by T. H. in 22 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
MY QUESTION IS ABOUT: Fixing Formulas DESCRIPTION: Search thru Column H and Column I, and IF the cell CONTAINs STRING A, STRING B, OR STRING C, return VALUE 1 OR if cell CONTAINs String D, String E, OR STRING F, return VALUE 2, OR if cell CONTAINs String G, OR String H, return VALUE 3 Otherwise, return UNKNOWN.
Solved by M. H. in 20 mins