TEXTJOIN missing from MS Office Home and Student 2016

You can add Text Join Funtionality to Excel using a User Defined Function.

If you paste this code into your Personal workbook then you will be able to use Textjoin on all your workbooks.

The simplest way to access your personal workbook is:-

Select your developer tab and select record macro,

make sure that a. you select the option to record in your personal workbook.
b. you make a note of the macro name

Select a cell and type something like "Test"

Stop the Macro Recorder.

Select the Developer tab and then run Macro

Select your Macro and then "Step Into"

You should be able to see your new Macro. So Delete it.

Paste the code below into the same place. Close the module.

Quit excel, Remembering to save changes to your personal workbook.

Thats it you now have the Textjoin function.




https://www.get-digital-help.com/201...join-function/

Please Login or Register  to view this content.

It seems like there are a few functions (I think TEXTJOIN() might be one of them) that requires that you also have an Office 365 subscription. I don't know where in MSFT's documentation you would look to verify if this is the case.

Originally Posted by MrShorty

It seems like there are a few functions (I think TEXTJOIN() might be one of them) that requires that you also have an Office 365 subscription. I don't know where in MSFT's documentation you would look to verify if this is the case.

This link https://support.office.com/en-us/art...3-0e8fc845691c

Then click "More..." in the first (italicized) line.
Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2019 for Mac More...

Agreed. ______________________

Get the subscription model - you will always be up-to-date then.

Yes you will have issues if you pass the workbook to someone who has the textjoin function.

luckily all you need do is name your function TextJoin2

mehmetcik,

I copy and pasted the code you have attached into a new module on my spreadsheet with no luck. The formula just returns #NAME? Not sure what the issue is and was wondering if you could help me, as this is the only reference I can find online for adding textjoin into excel for Mac (evil MS!) The other members of my company who will be viewing this spreadsheet have Macs and therefore won't have this code built in either. Also, I was wondering if I will be able to use this function with array formulas.

Thank you so much for the help!

EDIT: Got it working! You must label the module something other than TEXTJOIN for the function to work!

Hi Nick.

The only reason you would get #NAME? is if you have pasted the function into the wrong Macro Module.

Post your Spreadsheet so I can see what you are doing.Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.