Concatenate multiple lines

[ZootRot]

Excel 2007

I have a whole spreadsheet with paragraphs of text in multiple cells (line
per cell). For each column, I need to concatenate these lines into a single
multi-line cell.

Currently I'm manually typing in a formula [=a1&b1&c1], then copying and
pasting the resulting value. Immensely time consuming. I've tried to use
=concatenate(a1:a3), but that produces a #value error.

Other than using VBA, is there an easier way to do this?

Thanks.

 

[Don Guillett]

Unless I'm missing something, can't you just drag your formula down?
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

 

[Nick Vivian]

you'll need this then !
http://excelexperts.com/VBA-Tips-Concatenate-Range

Nick