Forum Discussion
roniexcel2020
Oct 13, 2020Copper Contributor
copying spread words to one column
Hi I teach basic excel and a student of mine asked me a question i did not know the answer to. For some reason he has got an excel sheet with lots of words spread in over columns and rows, some wit...
HansVogelaar
Oct 13, 2020MVP
For example in A1:
=TEXTJOIN(" ",TRUE,B1:Z1)
Expand the range if the data extend beyond column Z.
This can be filled down.