Line Break

[Paolo]

Hi, would like to join two strings, but including in the middle a new line

es. ="aaa"&"bbb

the result i want to see the cell is not aaabbb bu
aa
bb

 

[Frank Kabel]

Hi
try
="aaa" & CHAR(10) & "bbb"
and format the resulting cell with word wrap

 

[Paolo]

Great

Thanks very much for your precious help

Paol

----- Frank Kabel wrote: ----

H
tr
="aaa" & CHAR(10) & "bbb
and format the resulting cell with word wra

-
Regard
Frank Kabe
Frankfurt, German