Merging text from one cell to another. Easy way?

[dirtdart]

I saved a chat history from a .csv file to ods. The messages were separated across multiple cells in each row.
Like this:

A    | B                       | C          | D              | E                |
Sent | August 9 2017 10:21 AM  | Hey, how's | it going today | ?I am home sick. |

I would like all the messages contained in a single column. I’ve been cutting text from E and D and then pasting into C. With 5 years of chat, it will take quite a long time to get all the text combined into Column C. Please tell me there is an easier way to do this.

[anon73440385]

Hello,

check function TEXTJOIN(), e.g =TEXTJOIN(" ";0;C1:E1), if all cells are really text- If there are numerical values, like dates or times you need a more elaborated formula.

Hope that helps.

[EarnestAl]

Create a new column C before the existing column C. Enter a formula in C1 =D1&E1&F1, etc.

Possibly, you will need to add spaces between words, =D1&" "&E1&" "&F1

Copy the formula down, then select the column, copy and paste special as text

[dirtdart]

Big THANKS to both of you.