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!”
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