=CONCATENATE(B1;" ";C1;" ";D1;" ";E1;" ";F1;" ";G1;" ";H1;" ";I1)
Then Select column copy the cell.
Once the column is full of phrases. Copy the column and paste as special
OpenOffice Calc: Join cells with words into one phrase with spaces between words
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.