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.

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.

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.