“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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