Text Next Line

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

Guest

=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.
 
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!
 
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
 
Back
Top