Excel 2016 - TextJoin causes #Name? Error

lnagel

Board Regular
Joined
May 28, 2018
Messages
117
Only occurs in Excel 2016

Works in all other versions of Excel that I have tested (2010 and O365)

Trying to set the contents of a cell to equal :

=TEXTJOIN(" ",TRUE,"Some Text : ",CG1)

CG1 is a cell that does contain text (formatted as Geeral but have tried formatting as text also)

Have googled the issue for 2016 but nothing pops up as "OH That's It"

Any Ideas?
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Still puzzled as I didn't think TEXTJOIN came in until 2016/365.


TEXTJOIN function



Applies To: Excel for Office 365, Excel for Office 365 for Mac, Excel 2016, Excel 2016 for Mac, Excel Online, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones, Excel Mobile, Less


but further down it states the below which seems like it is relevant to you

Note: This feature is only available if you have an Office 365 subscription. If you are an Office 365 subscriber, make sure you have the latest version of Office.

https://support.office.com/en-us/article/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c

https://support.office.com/en-us/ar...abetical-b3944572-255d-4efb-bb96-c6d90033e188
 
Upvote 0
Typically, #NAME ? in response to a formula entry indicates that one or more of the functions used in the formula doesn't exist in the version of Excel running.
 
Upvote 0
Hi,

I use Excel 2016 on a PC, I assure you, TEXTJOIN is Not available, neither is IFS, MAXIFS, among many other functions available Only thru a 365 subscription.
 
Upvote 0
@ lnagel

Since you have a single cell to evaluate, you don't need TEXTJOIN which you probably don't have on your Excel system, why don't you just invoke the following?

=IF(LEN(CG1),
"Some Text : "&CG1,"")
 
Upvote 0
Yes - I finally figured out that Textjoin is not available in 2016 - changed the formula to =" The text I want to Display " & CG1

Thanks all -
 
Upvote 0
Yes - I finally figured out that Textjoin is not available in 2016 - changed the formula to =" The text I want to Display " & CG1

Thanks all -

You are welcome, but try the full suggestion...

@ lnagel

Since you have a single cell to evaluate, you don't need TEXTJOIN which you probably don't have on your Excel system, why don't you just invoke the following?

=IF(LEN(CG1),"Some Text : "&CG1,"")

otherwise you get something like:

SPACEThe text I want to DisplaySPACE

an invisible char when CG1 is empty or blank.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,207
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top