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%22%3Ehttps%3A%2F%2Fbettersolutions.com%2Fexcel.htm%3C%2FA%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
New Contributor
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)