how to concatenate a newline?

  • Thread starter Thread starter Lee Harris web
  • Start date Start date
L

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