Go to Visual Basic Editor Press AltF11 Insert a new module Press AltIM Paste this code.

How to use textjoin in excel 2007. The syntax of the Textjoin function is. REPLACE REPT F1ISNUMBER FIND F1A1REPT F2ISNUMBER FIND F2A1. Save workbook as macro enabled.

You dont have to copy and paste you can type it in as well. In the screen shot below theres a simple TEXTJOIN formula in cell D3. TEXTJOIN TRUE A1A3 The second argument ignore_empty controls.

To use this code below are the steps-Copy the below given code. In the above image you can see that all the three texts have been joined and there is space between each text. This function will help users not only joining the text but also allows to give a delimiter with the choice of including or excluding blank cells in a given range.

Now just drag the cursor to copy the formula and you can the results. To join cells in the range A1A3 with a comma and space you can use TEXTJOIN like this. In this basic example we would like to join the texts in B4 and C4 cells.

To do this you will go to the insert tab and then go to the text box and select text box. The Excel Textjoin function joins together a series of supplied text strings into one combined text string. Yes earlier versions arent great when it comes to working with Text Arrays.

If the delimiter is an empty text string this function will effectively concatenate the ranges. Now draw yourself a text box then highlight and copy the text you want then paste it in. Go to the worksheet and type My_Text_Join and use it as normal excel function.