| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CONCATENATE
=CONCATENATE(A5,B5,C5,D5,E5,F5,G5,H5,I5,J5,K5)
how can i get J5,K5 on the next line to look like A5,B5,C5,D5,E5,F5,G5,H5,I5, J5,K5 thanx, paul m. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CONCATENATE
Paul,
Use CHAR(10) to insert a line break. E.g., =A5&B5&C5&D5&E5&F5&G5&H5&I5&CHAR(10)&J5&K5 Ensure that Wrap Text is set for the cell (Format menu, Cells, Alignment tab). -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "AYPCN" wrote in message ... =CONCATENATE(A5,B5,C5,D5,E5,F5,G5,H5,I5,J5,K5) how can i get J5,K5 on the next line to look like A5,B5,C5,D5,E5,F5,G5,H5,I5, J5,K5 thanx, paul m. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CONCATENATE
LHPA\PMiller-38420| LM w/ FML for John Doe to Cll Bck
HFUP,38421 so that way when i copy the cell and past it in to notepad thanx "AYPCN" wrote: =CONCATENATE(A5,B5,C5,D5,E5,F5,G5,H5,I5,J5,K5) how can i get J5,K5 on the next line to look like A5,B5,C5,D5,E5,F5,G5,H5,I5, J5,K5 thanx, paul m. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate | Excel Discussion (Misc queries) | |||
| Concatenate | Excel Worksheet Functions | |||
| CONCATENATE | Excel Worksheet Functions | |||
| Concatenate | Excel Discussion (Misc queries) | |||
| I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
Linear Mode
