Get instant live expert help on I need help with concatenation in excel

“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 a column in an Excel table that is a concatenation of several columns all within the same row. For Example A2= Ron Smith, 456763, US. B2=US. C2=Ron Smith. D2=37. After concatenation is made the column is transformed to an all text value. The file is converted in CSV to process. But then in some cases there has been data shift. So before loading the file it is required to verify that the data contained in A2 matches B2, C2 and D2 instead of A4, C5, D3.
Solved by T. S. in 24 mins
Calculations/functions simply will not behave. At my wits end with very simple concatenation of text cells. Options are set to "Automatic" calculation. If I enter the function =Concatenate(G4,G5), it returns the formula, not the result. I can F2/F9 and it will calc, but then I cannot copy the formula down the rows. "Calc Now" and "Calc Worksheet" do nothing. If I alternatively type =G4&G5, same result.
Solved by I. H. in 11 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 Excels RANDBETWEEN() function.
Solved by T. Q. in 26 mins
i need help in dates in excel , how to count dates in excel ,
Solved by S. E. in 20 mins
In Microsoft excel, what is Survival analysis test in Microsoft excel. Must have a strong actuarial and Microsoft excel command.
Solved by D. D. in 26 mins