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!”
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