Get instant live expert help on I need help with vba convert 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 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
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
How do I find all formulas in 32 sheets over hundreds of rows that contain a partial string such as "This Company" where the formula looks like "=if(H2 = "This Company", "Yes","No"). This is a bit more complicated, but the upshot is that I need ti use VBA to locate formulas where the partial contents match a specific string. Any suggestions?
Solved by X. C. in 28 mins