Text Join Formula for all Excel Versions

Hello Friends,

In this video you will learn how to create user defined function for Text join in Excel.

Syntax for this UDF: PK_Text_Join(delimiter, ignore_empty, text_range)

Please download this excel file from below given article:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Twitter:

Pinterest:

Send me your queries on telegram:
@PKanExcelExpert

[annaloriemartha]

OMG THANK YOU SO MUCH YOU HELPED ME A LOTTTT THIS IS SUCH A BIG ACHIEVEMENT FOR ME

[MrJeffg]

Hi PK, thank you for sharing your knowledge of Excel. I have found it extremely useful. also thanks for sharing your workbooks as it makes it easier to learn when watching your videos!!! thanks once again mate!

[Alex-tedo]

Thank you so much for this! exactly what I needed and my excel is 2016. Liked and subscribed!

[mikevanwieringen]

Thank you very much for this very helpful custom function...Highly appreciated !

[widywijaya]

thanks a lot, its help me a lot in my job..., God bless you

[ibrahimsubas]

Hello, many many thanks for this function. İt's very useful.

[Pankaj-Verma-]

Thank you so much for your kind help~!

[wallynillos]

Hi sir
Very helpul to all old version excel users
How can use IFcondition to add in your formula..thanks

[yudistirafardana]

terima kasih pk, saya ingin bertanya. bagaimana jika data tersaji secara vertikal?

[borispajk]

hello PK,
I copy the entire VBA code for text joining function, but the result is #name? so clearly is something wrong with my name, I rename it but there is the same issue, maybe you have a clue where I'm wrong?

[juanbetancourt]

Awesome, thanks for sharing it, by the way, I didn't understand why the Boolean code works in both cases if you just copy the same code for true and false case (I bet it should be different at some point).

[borofornes]

Gracias por tu vídeos son una pasada "amaizing". ;)

[alyssaharvey]

How could you change this formula to ignore cells that don’t have any text/number but are not empty? For example I have cells with formulas that display “” and I don’t want these blanks to show up in my list.

[yeders]

Hi there - your website link seems to be down.

[ORANGEPICTURESOFFICIAL]

make a video on riverse to if we have 1's into one

[swapnilshere]

Hi pk,
Can we use this formula in combination with other formulas.

[ramsharma]

how can we create a list of employee (in a column) if we have list of employee in sentence case.. just as reverse of this case?

[ShaibulHoqueMozumder]

Sir
Please share "IFS" function add in to use in excel 2013

[hobbytotravel]

guys can anyone help me for this question
1) do one formula is use for all version of excel?

[muhammadimranbukhari]

Commas still shown even all blanks cells