Concatenate multiple lines

  • Thread starter Thread starter ZootRot
  • Start date Start date
Z

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.
 
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.
 
Back
Top