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

Hi, I need to automatically add 1 in D17/H00001, CONCATENATE(LEFT(A1,9),RIGHT(A1,1)+1) it's not working properly, means problem for entering to last 2 digits,
Solved by I. U. in 22 mins
I need to concatenate two long columns into one and I don't know how to do it; I'm horrible with excel. Please help! :)
Solved by T. D. in 23 mins
I need help I believe with a concatenate formula.
Solved by Z. Y. in 19 mins
In cell C1, use a formula to find If values exist in column A and B of the row, then concatenate the last name first, a comma, a space, and the first initial of the first name into column C of the corresponding row
Solved by I. L. in 23 mins
I need an explanation for this formula: =IF(G3="OnDemand",(VLOOKUP(CONCATENATE($B$1,C3,D3,E3," ","shared","hrs"),'AWS_8.1.17 Hardware'!B2:BT200000,11,FALSE))*730*J3*I3,IF($F3="Convertible No Upfront",(VLOOKUP(CONCATENATE(B$1,C3,D3,E3,H3,F3,"shared","hrs"),'AWS_8.1.17 Hardware'!B1:BR78560,11,FALSE)*730*J3),IF($F3="Standard No Upfront",(VLOOKUP(CONCATENATE(B$1,C3,D3,E3,H3,F3,"shared","hrs"),'AWS_8.1.17 Hardware'!B1:BR78560,11,FALSE)*730*J3),IF($F3="Standard All Upfront",(VLOOKUP(CONCATENATE(B$1,C3,D3,E3,H3,F3,"shared","quantity"),'AWS_8.1.17 Hardware'!B1:BR78560,11,FALSE)/12*J3)))))
Solved by G. D. in 26 mins
Let me know what is the error in below formula =VLOOKUP(CONCATENATE(TEXT(A3; "dd-mmm-åååå");" "; B3);'Daily Overall Snap'!(CONCATENATE(TEXT($A; "dd-mmm-åååå");" ";$B)):$Q;3;FALSE)
Solved by E. C. in 16 mins
Hi, I am currently working on a formula but it keeps on displaying an error warning. SUBSTITUTE(IF(Main!C5="Car",'Gallery Index'!$F$3,IF(Main!C5="Bike",'Gallery Index'!$G$3,IF(Main!C5="Truck",'Gallery Index'!$H$3,IF(Main!C5="Bus",'Gallery Index'!$I$3))),"{{title}}",CONCATENATE("<center>",CLEAN(UPPER(Main!D5))))," ",CLEAN(UPPER(Main!E5)),"<br>",CLEAN(UPPER(Main!F5)),"<br><br><u><mark>",CLEAN(UPPER(Main!G5)),"</mark></u><br>","PART NUMBER: ",CLEAN(UPPER(Main!H5)),IF(Main!R5>1,CONCATENATE(" (X",Main!R5," PCS)<br><mark>TOTAL: X",Main!R5," ITEMS</mark>"),""),"<br><br>","ITEM DETAILS:<br>THIS IS A BRAND NEW ",IF(Main!AC5,"AFTERMARKET ITEM",CONCATENATE("ITEM<br>MANUFACTURED BY ",CLEAN(UPPER(Main!D5)))),"</center>",IF(Main!C5="Car",'Gallery Index'!$F$4,IF(Main!C5="Bike",'Gallery Index'!$G$4,IF(Main!C5="Truck",'Gallery Index'!$H$4,IF(Main!C5="Bus",'Gallery Index'!$I$4))) Here is the formula.
Solved by D. A. in 24 mins
Advanced Excel function: index vlookup, if then I have a two tab worksheet. Tab one contains two columns, first and last name, the second tab contains first, last name, and a total. I have tried to use a concatenate function to compare, however it failed. I need to compare the name and place a total on tab one if it is a match. Vlookup works, but if the first name is incorrect that proves a challenge.
Solved by S. F. in 19 mins
Use CONCATENATE to formulate your answers. Each answer should follow this template: Name of actor/director/MovieTitle won in the category of CATEGORY (the category name needs to be displayed like this: Best Director, Best Picture etc.) in YEAR (only the year, not the full date).
Solved by F. B. in 15 mins
I need to concatenate values in column K that share the same value in column B and Dedupe extra rows that share the same value in column B. The only info that is different is the info in column K that i want to concatenate
Solved by M. J. in 17 mins