TEXTJOIN() Function to Combine Text in Excel - Excel Quickie 51

This tutorial covers the new TEXTJOIN() function for Excel 2019 and Excel 365 that allows you to easily combine ranges of text, hardcoded values and even transform the text in the process of concatenating it.

This tutorial includes 3 sets of examples for the TEXTJOIN() function.

This is a new function for Excel 2019 and 365 and it is long overdue - finally we can use a single function to combine a lot of text, values or numbers instead of concatenating everything by hand or in a piecemeal manner.

This new function replaces the need for a UDF (User Defined Function), which is what you used to have to use to achieve the same thing.

I hope you enjoy this tutorial!

#excel #tutorial #excelquickie

[wayneedmondson]

Nice tips.. thanks for sharing. Thumbs up!!

[toxiqrox]

Thank you, so easy when you know how. I have not had anything to do with formula and you make it make sense finally

[darrylmorgan]

Wicked Little Function Also Really Handy To Learn TEXTJOIN And CONCAT For Those Who Take The 2019 Microsoft Office Certification....Great Stuff Thank You Sir :)

[IvanCortinas_ES]

Thank you for the information. All's ok!!

[jawaharlalreddy]

Sir pl send text joining function using concetenta

[fredlevel]

"Ignore empty" is probably the only real added value of this function but that's one I will keep in mind

[subramanirangasamy]

Excellent, this is related to Concatenate function. I tried excel 2010 not working any

[jonnathanjon]

Wondering how do you include that as part of a vba which I do not want mention a fixed range?

[decg]

Hi
Is it possible if you have retail price in one column, For example, simplest way for me to explain
Any figures between 17.01 and 17.50 goes to 17.45

Any figures between 17.51 to 17.99 goes to 17.95
Thank you

[alimohamedahmed]

First of all thank you so much
Second I am using office 2016, and I couldn't find this formula , could plz help me to fix this problem