Get instant live Excel expert help with CONCATENATE Function

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,

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! :)

I need help I believe with a concatenate formula.

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

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)))))

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)

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.

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.

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).

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