Get instant live expert help on I need help with concatenation function in excel
“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 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
In EXCEL 2016 HOUR Function in SQL fails with "Hour is not a recognized function
Solved by M. J. in 15 mins
I need help on how to use indirect function along with sumifs function in excel.
Solved by Z. W. in 15 mins
Problems will the DATEDIF function in excel.
Solved by X. U. in 25 mins