Text Next Line

[AYPCN]

=A5&TEXT(B5,"mmddyy")&C5&D5&E5&F5&G5&H5&I5&J5&K5

J5&K5 needs to be on next line

and how do i get K5 be like B5,mmddyy

thanx so much.

 

[Dave R.]

Add &CHAR(10) before &J5, and make sure cell is formatted to wrap text
(format>cells>alignment|text control)

As for how you get K5 like B5, see what you did for B5 and do the same for
K5!

 

[Peo Sjoblom]

Turn on text wrap under format>aligment and then put

&CHAR(10)&

in-between where you want the new line and make sure the cell is large
enough to hold it