| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Text Next Line
=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. |
|
#2
|
|||
|
|||
|
Add &CHAR(10) before &J5, and make sure cell is formatted to wrap text
(formatcellsalignment|text control) As for how you get K5 like B5, see what you did for B5 and do the same for K5! "AYPCN" wrote in message ... =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. |
|
#3
|
|||
|
|||
|
Turn on text wrap under formataligment and then put
&CHAR(10)& in-between where you want the new line and make sure the cell is large enough to hold it -- Regards, Peo Sjoblom "AYPCN" wrote in message ... =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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add another line in cells with existing text? | New Users to Excel | |||
| Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
| Why text to columns is not available when there is mulipule line . | Excel Worksheet Functions | |||
| Adding a text label to a line. | Charts and Charting in Excel | |||
| Forcing text onto new line in cell | New Users to Excel | |||
Hybrid Mode
