TEXTJOIN NOT WORKING IN EXCEL (MICROSOFT 365)

Question

I am trying to use TEXTJOIN in Excel (from Microsoft 365) but get an error each time I do so.

My formula is =TEXTJOIN(";",TRUE,C3:G3) and this is what it keeps doing:

The error message:

Answer 1

I have just this second worked it out and came to say I had.

A while ago I changed the default delimiter in Region Settings, from a comma due to my data having commas in it. This is why formula's with commas weren't working. I simply had to change it back to a comma.

Problem solved!

Answer 2

Hello,

Welcome to Microsoft Community.

I am a Microsoft user just like you, I hope you are doing well?

The TEXTJOIN function concatenates multiple values together with or without a delimiter. TEXTJOIN can concatenate values provided as cell references, ranges, or constants, and can optionally ignore empty cells.

The TEXTJOIN function takes three required arguments: delimiter, ignore_empty, and text1. Delimiter is the text to use between values that are concatenated together and should be enclosed in double-quotes (""), for example, a space (" ") or a comma with a space (", "). To use no delimiter, supply an empty string (""). Ignore_empty is a Boolean (TRUE/FALSE) value that controls whether empty values should be ignored or added to the result. This is often set to TRUE to avoid delimiters with no content in the result from TEXTJOIN. Text1 is the first value to join together. This can be a cell reference, a range, or a hard-coded text value. Subsequent optional arguments, text2, text3, text4, etc. can be provided up to 252 values total.

Values are concatenated in the order they appear. With "Hello" in A1 and "World" in A2, the following formula returns "Hello World":

=TEXTJOIN(" ",TRUE,A1,A2) // returns "Hello World"

Changing the delimiter to a comma (", ") and reversing A1 and A2, we get "World, Hello":

=TEXTJOIN(", ",TRUE,A2,A1) // returns "World, Hello"

Concatenating a range To join cells in the range A1:A3 with a comma and space, you can use TEXTJOIN like this:

=TEXTJOIN(", ",TRUE,A1:A3)

Find more information on TEXTJOIN: https://exceljet.net/functions/textjoin-function

Disclaimer: There are links to non-Microsoft websites. The pages appear to be providing accurate, safe information. Watch out for ads on the sites that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the sites before you decide to download and install it.

Please let me know if you need more assistance.

Give back to the Community, Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

Warm Regards

Answer 3

Thank you, I'd already seen that page. I sent a few lines of the data to a friend who also has the same version of excel and they used my formula and it worked straight away. I suspect i must have some option/setting that's been changed which is stopping formula from working properly. Thank you for your assistance.

Answer 4

Have you figured out why the formula doesn't work on your Excel?

Answer 5

I'm glad this issue has been resolved