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

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
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
How do I calculate all permutations (concatenate) of each column of 7 rows without having to manually do such?
Solved by X. S. in 20 mins
I have 3 columns with data that I want to combine into one single column (not concatenate) if a certain criteria is met. In addition I also want: Blank and/or zero lines to be skipped Negative numbers to be made positive All numbers to be rounded. I think I have some of the parts of the formula but I am missing others, and don't really know how to combine it all.
Solved by V. L. in 24 mins