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

Copper Contributor

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?

0 Replies