Concatenate IF | TEXTJOIN IF | Concatenate IF Cell Contains Text | Concatenate with IF Condition

Download the featured file here: www.bluepecantraining.com/wp-...
In this video, I demonstrate how to combine concatenation with an IF condition.
In the first scenario, I only want to concatenate a cell if it contains a text value. If the cell is empty I don't want it to be included in the concatenated text string.
In the second scenario, I want to concatenate values in a column if a condition is met in another column. I use the TEXTJOIN function to achieve this.
------------------------

[@lililou5587]

You cannot imagine how grateful I am for your tutorial. The last example you showed is exactly what I needed and I've been searching on UA-cam and the internet for this since I can remember. I'm so happy 😊. Thank you !!

[@carlosivanem]

Thank you very much! That TEXTJOIN trick just saved a project I thought was doomed :D

[@IvanCortinas_ES]

Fantastic tutorial Chester. I love TEXTJOIN function! Thank you.

[@chrissturgeon6818]

Great video, thank you. The deliminator I used was to go down a line. Worked perfectly.

[@ryuzakiwashere47]

I've been looking for this for ages! Thank you very much! '😍

[@ubaidillahmuhammad20]

loved it

[@Ibrahimalaabed]

you are genius , especially the last one .

[@Afarsekk]

thank you I finally got it

[@seanhevey9664]

Cannot thank you enough!

[@augenkeit]

Thank you!!!

[@antonelloguadambino7974]

Thanks

[@alializadeh8195]

Thanx

[@xbexsunny]

great

[@freyalunn]

Fantastic video! I would have said I'm rather good at Excel but didn't know about the "&" method, or TEXTJOIN! I'm actually looking for a way to create a "Full Name" column, but having data pulled from a "Known As" column if the data exists, if not, look at "First Name". I can get it to do it separately but trying to minimise the amount of columns I have so was looking at nesting the formulas using If and Concatenate. Any thoughts?

[@justinvincent4908]

This is exactly what I need to do in the second example, but it isn't working for me. In your example the result I am getting is bringing all values in column A to each cell in column E and only if the values in B2 and D2 are equal, otherwise it returns blank. So in E2, E3 in your example it pulls in all data from column A and E4-E6 are blank. Why is this happening?

[@maryjoybrownprayco8497]

How about 2 ifs?

[@coco99ca]

The cell with the answer has too much data and the textjoin cell stays blank? I know the formula is good, because it works with small amounts of data. How do I stop this error?