Combining 2 or more rows of text

[nikita]

I have text that is in 10 rows instead of just 1 row. How can I combine it quickly, without lose of text? I have a spreadsheet that has over 2000 rows like this. The original author did not know about wrapping text. grrrr

 

[Dan Waterloo]

You can concatenate text in in two or more cells by using the ampersand operator or the CONCATENATE function.

E.g., To combine the text in cells A1 to A10 you could write one of these two formulas:
= A1 & A2 & A3 & A4 & A5 & A6 & A7 & A8 & A9 & A10
= CONCATENATE(A1, A2, A3, etc)

This leaves you with a formula. If you want just the text then you should Copy it and Paste Special as Values.

You can also get clever and include linefeed characters using the CHAR function:
= A1 & CHAR(010) & A2 & CHAR(010) & A3 etc.

You need to format the cells as Wrap Text in order to attain the desired effect.