Get instant live Excel expert help with CONCATENATE Function

“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

Concat formula is incorrectly formatting the date in column C. Currently column B has dd/mm/yyyy and I require mm/dd/yyyy
Solved by Z. Y. in 19 mins
I am having difficulty getting the Concat function with two strings to concatenate and display desired results. How am I supposed to concatenate cells in excel?
Solved by Z. D. in 30 mins
Hello. I need to use the CONCAT function. I have several numbers in A1-A15, and in B1-B15 I need it to show the same number but with i: in front, and ; in back. Example: A1 number: 109137 B1 Number should become: i:10285; I have tried using this formula in B1, without success: =CONCATENATE("i:",A1,";")
Solved by C. S. in 27 mins
Hi, I need to concatetate a cell using data in a column - but have 600 of them. How do I put in a break so I only concat each product in the same column?
Solved by M. S. in 29 mins
I have an issue where my CONCAT formula is not returning a result. I have office 365 subscription (2016 excel), and I have written my formulae correctly (checked in function arguments, however the expected result (as identified) is not being returned...in fact no result is returned...the formula stays the same... any suggestions?
Solved by M. A. in 25 mins
CONCAT FUNCTION NOT WORKING I NEED TO CONCATENATE TEXTS FROM SEVERAL ROWS, BUT AFTER USING CONCAT FUNCTION ONLY FIRST ROW IS APPERAING. HELP
Solved by E. U. in 11 mins
Hi guys, trying to concatenate data from multiple rows in a single column to a single cell. The problem I have is that it needs to discriminate when it hits a certain row and start a new cell. Not sure how to do the discriminate part
Solved by V. U. in 25 mins
i need to know if you guys can make me a vba on concatenate function, i dont mind paying. thank you
Solved by O. F. in 18 mins
I want to concatenate all data but separated with coma
Solved by S. W. in 21 mins
I want to fix the decimal issue. I have 2 price column 1 is the cost of the product and other costs of the shipping. issue start after using excel concatenate() function
Solved by K. U. in 16 mins