New Line with Concatenation

  • Thread starter Thread starter bw
  • Start date Start date
B

bw

I enter the follow with <alt+enter> after the word Date to get the following
in cell A1:
Todays Date
03/02/05

I would like to get the same type of format with a concatenated value such
as below:
="Today's Date" & TEXT(NOW(),"dd/mm/yy")

Is there something I can use in a concatenated value to provide a new line
as with <alt+enter>?

Thanks,
Bernie
 
Hi Bernie,

="Today's Date"&CHAR(10)&TEXT(NOW(),"dd/mm/yy")

and make sure that word-wrap is set for the cell.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top