how to concatenate a newline?

[Lee Harris web]

Is it possible to concatenate two strings in excel such that they
appear in a single cell but on different "lines",

eg

A1: Hello
A2: There
B1=concatenate(A1,A2)

I want it to look like

Hello
There

rather than Hello There

but still be in a single cell
tks in advance

 

[Ron de Bruin]

Hi Lee

copy this formula in B1

=A1&CHAR(10)&A2

Ctrl -1 (Format cells) with B1 select
On the alignment tab check wrap text

 

[Guest]

Lee,
You need to use CHAR(10) for the carriage return. Example:

=A1&CHAR(10)&B1

The cell need to be formatted with word wrap for this to work.

Good Luck,
Mark Graesser
(e-mail address removed)

----- Lee Harris web wrote: -----

Is it possible to concatenate two strings in excel such that they
appear in a single cell but on different "lines",

eg

A1: Hello
A2: There
B1=concatenate(A1,A2)

I want it to look like

Hello
There

rather than Hello There

but still be in a single cell
tks in advance