Get instant live expert help on convert string to array

“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 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
I have an array in a single cell with 14 values and I am trying to match those values to string on a different sheet.
Solved by S. U. in 26 mins
I need three simple array formulas: - if "Y" then "abc", elseif "N" then "xyz", else = nothing. - prefix whole column - fill whole column with specified string
Solved by D. D. in 24 mins
I have 2 columns, string of characters in one and numbers in another. I want to see which number corresponds to a particular string, e.g in array below, what corresponds to "g". a 1 g 5 v 7 g 9 n 3 n 8 w 0 f 6
Solved by C. U. in 11 mins