Text Next Line

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.
 
D

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!
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding cells but leaving blank if not populated 1
data from 1 sheet to the next 6
CONCATENATE 2
Help !!! 2
Date CONCATENATE 2
Help with Formula 7
Is there an Excel Function that can be used in lieu of this formul 5
How to simplify If / ElseIf statement 4

Top