# 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