Get instant live expert help on I need help with excel random string

“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

Example data sets: ABC5789A ABC5D789A Where "789" are a random string of three numbers that I need for my VLOOKUP formula. ABC5 is the only constant, but the data is written as one of these two ways.
Solved by F. F. in 22 mins
I need to take a string (without any spaces) and find parts of this string in other strings (without any spaces) in my workbook. The strings are just random letters and not full words, they have no spaces and I'm not sure exactly what I want to search for. I just want to find the matching sections of my different strings of data
Solved by V. U. in 12 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
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
how to fill blank spaces in excel with random numbers
Solved by D. C. in 30 mins