Get instant live expert help on concatenate text in excel

“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

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