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

I recently exported a bibliography from word into excel via text. The titles, all between and have varying lengths therefore diffent columns. Using concatenate how can I make a formula that only concatenates between cells where appears, i.e.a concatenate formula of varying columns?

Solved by T. Q. in 28 mins

I need help with excel concatenate formula.

Solved by E. S. in 11 mins

Could you please explain what is being referenced in the follow string? I am familiar with using INDIRECT and CONCATENATE together. =INDIRECT(CONCATENATE("'Sheet Name'!",K$1&$A6))

Solved by B. L. in 24 mins

Trying to solve I need to know if something exist in a cell, and if it doesnt then i need it to concatenate some absolute values Example - in cell B5 - it should concatenate K4,M4,O4,Q4

Solved by F. J. in 27 mins

This formula is placed in cell C3. =IF(ISBLANK(H3),"", IF(B3="Complete","", IF(H3>TODAY(),IF(TODAY()+H3<>1,CONCATENATE("Due in ",TEXT(TODAY()+H3,"d")," days"),CONCATENATE("Due in ",TEXT(TODAY()+H3,"d")," day")),IF(H3=TODAY(),"Due Today","Overdue")))) When the above formula is run and H3 is today or today-1, then the result in C3 is correct. When H3 is today+1 for example, the result in C3 is "Due in 9 Days". I cannot figure it out ?

Solved by B. U. in 16 mins