Home

TEXTJOIN function - Can’t see my error!

%3CLINGO-SUB%20id%3D%22lingo-sub-203087%22%20slang%3D%22en-US%22%3ETEXTJOIN%20function%20-%20Can%E2%80%99t%20see%20my%20error!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-203087%22%20slang%3D%22en-US%22%3EI%E2%80%99m%20trying%20to%20display%20text%20from%20one%20page%20of%20a%20worksheet%20in%20a%20cell%20on%20another%20page%2C%20and%20have%20tried%20various%20things%2C%20but%20keep%20getting%20the%20error%20%23NAME%3F%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20let%20me%20know%20if%20you%20can%20see%20what%20is%20wrong%20with%20the%20way%20I%E2%80%99ve%20written%20this%20function%3A%3CBR%20%2F%3E%3DTEXTJOIN(%E2%80%9C%20%E2%80%9C%2CTRUE%2CTops!C2%2CTops!D2%2CTops!B2)%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-203087%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-203152%22%20slang%3D%22en-US%22%3ERe%3A%20TEXTJOIN%20function%20-%20Can%E2%80%99t%20see%20my%20error!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-203152%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Beth%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20change%20quotation%20mark%20symbol%20from%26nbsp%3B%3CFONT%20color%3D%22%23FF0000%22%3E%3CSTRONG%3E%E2%80%9C%3C%2FSTRONG%3E%3C%2FFONT%3E-%20CHAR(147)%20on%20%3CFONT%20color%3D%22%23FF0000%22%3E%3CSTRONG%3E%22%3C%2FSTRONG%3E%3C%2FFONT%3E-%20CHAR(34)%20it%20shall%20work%3C%2FP%3E%0A%3CPRE%3E%3DTEXTJOIN(%3CFONT%20color%3D%22%23FF0000%22%3E%3CSTRONG%3E%22%20%22%3C%2FSTRONG%3E%3C%2FFONT%3E%2CTRUE%2CTops!C2%2CTops!D2%2CTops!B2)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-203099%22%20slang%3D%22en-US%22%3ERe%3A%20TEXTJOIN%20function%20-%20Can%E2%80%99t%20see%20my%20error!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-203099%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EThe%20arguments%20you%20have%20supplied%20to%20this%20function%20are%20correct%2C%20so%20I%20can%20only%20think%20of%20two%20reasons%20why%20you%20might%20be%20seeing%20a%20%23NAME%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20The%20first%20argument%20is%20not%20being%20recognised%20as%20text.%20Double%20check%20that%20the%20speech%20marks%20are%20being%20recognised%20as%20double%20speech%20marks%20and%20not%20invalid%20characters.%20If%20you%20copy%20this%20exact%20formula%20from%20the%20web%20page%20and%20paste%20it%20into%20Excel%2C%20you%20can%20reproduce%20this%20error.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2)%20You%20are%20using%20a%20version%20of%20Excel%20that%20does%20not%20support%20this%20function.%20This%20function%20was%20introduced%20in%26nbsp%3Ban%20update%20to%20Office%202016.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20Desktop%20you%20can%26nbsp%3Beasily%20check%20by%26nbsp%3Bselecting%20Insert%20Function%20on%20the%20Formulas%20tab%20and%20check%20that%26nbsp%3Ba%20description%20of%20the%20function%20is%20displayed%20at%20the%20bottom%20and%20that%20all%20the%20arguments%20are%20valid.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20Mobile%20you%20will%20have%20to%20look%20closely%20at%20the%20individual%20characters.%20Check%20that%20the%20double%20speech%20marks%20are%20pointing%20straight%20down%2C%20and%20not%20slightly%20forward.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%3EHope%20this%20helps%3C%2FDIV%3E%3CDIV%3ERussell%3C%2FDIV%3E%3CDIV%3E%3CA%20href%3D%22https%3A%2F%2Fbettersolutions.com%2Fexcel.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fbettersolutions.com%2Fexcel.htm%3C%2FA%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Beth ten Have
Occasional Visitor
I’m trying to display text from one page of a worksheet in a cell on another page, and have tried various things, but keep getting the error #NAME?

Please let me know if you can see what is wrong with the way I’ve written this function:
=TEXTJOIN(“ “,TRUE,Tops!C2,Tops!D2,Tops!B2)
2 Replies

Hi,

The arguments you have supplied to this function are correct, so I can only think of two reasons why you might be seeing a #NAME?

 

1) The first argument is not being recognised as text. Double check that the speech marks are being recognised as double speech marks and not invalid characters. If you copy this exact formula from the web page and paste it into Excel, you can reproduce this error.

 

2) You are using a version of Excel that does not support this function. This function was introduced in an update to Office 2016.

 

For Desktop you can easily check by selecting Insert Function on the Formulas tab and check that a description of the function is displayed at the bottom and that all the arguments are valid.

 

For Mobile you will have to look closely at the individual characters. Check that the double speech marks are pointing straight down, and not slightly forward.

 

Hope this helps
Russell

Hi Beth,

 

If you change quotation mark symbol from  - CHAR(147) on " - CHAR(34) it shall work

=TEXTJOIN(" ",TRUE,Tops!C2,Tops!D2,Tops!B2)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies