Conditionally Join Texts With TEXTJOIN and IF functions in Excel
There is one function in Excel that I wish Microsoft will eventually release in the future, and that's TEXTJOINIF function, to allow conditionally join texts or cells based on criteria. And since such function does not exist currently in Excel, therefore, I am going to demonstrate how we can use TEXTJOIN and IF functions to join texts together.
Buy Me a Coffee? Your support is much appreciated!
PayPal Me: https://www.paypal.me/jiejenn/5
Venmo: @Jie-Jenn
To download the exercise file: https://drive.google.com/uc?export=do...
More tutorial videos on my website → https://LearnDataAnalysis.org
Supporting my channel so I can continue keep making free contents
-------------------------------------------------------------------------------------------------------------
By shopping on Amazon → https://amzn.to/2JkGeMD
By become a member on Patreon → / jiejenn (Will gradually adding more benefits as I see fit)
#ExcelTutorial #TEXTJOIN #IF
Watch video Conditionally Join Texts With TEXTJOIN and IF functions in Excel online without registration, duration hours minute second in high quality. This video was added by user Jie Jenn 13 August 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 15,311 once and liked it 109 people.