Home

TEXTJOIN produces a list on-screen but I can't copy it (can only copy formula)

%3CLINGO-SUB%20id%3D%22lingo-sub-469161%22%20slang%3D%22en-US%22%3ETEXTJOIN%20produces%20a%20list%20on-screen%20but%20I%20can't%20copy%20it%20(can%20only%20copy%20formula)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-469161%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20column%20of%20stock%20symbols%2C%20and%20I%20need%20a%20csv%20file%20of%20these%20symbols.%26nbsp%3B%20I%20used%20TEXTJOIN%20formula%20(%3DTEXTJOIN(%22%2C%22%2C%2Carray%20of%20column%20cells).%26nbsp%3B%20Results%20are%20show%20in%20the%20formula%20cell%20--%20but%20if%20I%20try%20to%20copy%20the%20results%2C%20I%20only%20get%20the%20formula.%26nbsp%3B%20I%20assume%20I've%20changed%20some%20parameter%20for%20the%20spreadsheet%2C%20because%20I've%20used%20this%20many%20times%20in%20the%20past.%26nbsp%3B%20Thoughts%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-469161%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
stock73
Occasional Visitor

I have a column of stock symbols, and I need a csv file of these symbols.  I used TEXTJOIN formula (=TEXTJOIN(",",,array of column cells).  Results are show in the formula cell -- but if I try to copy the results, I only get the formula.  I assume I've changed some parameter for the spreadsheet, because I've used this many times in the past.  Thoughts?