Get instant live expert help on I need help with 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 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
Hey I need help with VBA. The first functions that you will create are helper functions that can be used by otherfunctions. Function FindMax(valueArray, nameArray) As String This function takes in two arrays; the first array has the numeric values while thesecond array has the names. The function will find the value in the first array that isthe largest and return the corresponding name (from the second array). For instance, if the valueArray = (10, 20, 5, 9) and nameArray is (“House”, “Chair”, “Table”, “Book”). The function will return Chair.
Solved by F. A. in 24 mins
Write a sub that does the following: It first generates a random winning number and stores it in a string variable (so that you can use string concatenation), and it asks the user how many cards they want to buy. It then uses a For loop to generate that number of cards and store their numbers in a card array (which should be a String array). Next, it uses a Do loop to keep checking cards until a winner has been found or no more cards remain. Finally, it displays a message stating whether you are a winner and your net gain or loss. Note that you can generate a single random digit from 0 to 9 with Excel’s RANDBETWEEN() function.
Solved by T. Q. in 26 mins