Line Break

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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