[SOLVED] Need to insert line-feed in Excel concatenation (VB)

I want to concatenate values from multiple cells into one cell. I want a
line-feed separating the values in the combined cell. I tried using the
ASCII character code (10 for linefeed, 13 for carriage return), but its not
working the way I did it.

Any help is greatly appreciated.

="a"&CHAR(10)&"b"

Format>cells>Alignment, check Wrap text

--
Kind regards,

Niek Otten

"Susan W" <Susan [email protected]> wrote in message
news:[email protected]...
>I want to concatenate values from multiple cells into one cell. I want a
> line-feed separating the values in the combined cell. I tried using the
> ASCII character code (10 for linefeed, 13 for carriage return), but its
> not
> working the way I did it.
>
> Any help is greatly appreciated.
>
>

Susan,

Try something like

=A1&CHAR(10)&A2

or, in VBA

Range("B1").Value = Range("A1").Value & Chr(10) &
Range("A2").Value

Ensure that the cell has Wrap Text enabled (Format menu, Cells,
Alignment tab).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Susan W" <Susan [email protected]> wrote in message
news:[email protected]...
>I want to concatenate values from multiple cells into one cell.
>I want a
> line-feed separating the values in the combined cell. I tried
> using the
> ASCII character code (10 for linefeed, 13 for carriage return),
> but its not
> working the way I did it.
>
> Any help is greatly appreciated.
>
>

Yes - the Chr(10) did it. Thanks very much!
Susan

"Chip Pearson" wrote:

> Susan,
>
> Try something like
>
> =A1&CHAR(10)&A2
>
> or, in VBA
>
> Range("B1").Value = Range("A1").Value & Chr(10) &
> Range("A2").Value
>
> Ensure that the cell has Wrap Text enabled (Format menu, Cells,
> Alignment tab).
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
>
> "Susan W" <Susan [email protected]> wrote in message
> news:[email protected]...
> >I want to concatenate values from multiple cells into one cell.
> >I want a
> > line-feed separating the values in the combined cell. I tried
> > using the
> > ASCII character code (10 for linefeed, 13 for carriage return),
> > but its not
> > working the way I did it.
> >
> > Any help is greatly appreciated.
> >
> >
>
>
>