CONCATENATE

G

Guest

=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.
 
C

Chip Pearson

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
 
G

Guest

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
 

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

Is there an Excel Function that can be used in lieu of this formul 5
How to simplify If / ElseIf statement 4
How to simplify If / ElseIf statement 4
Circular Express when $ added 2
SUMIF every 2nd cell 8
Help !!! 2
Text Next Line 2
Adding cells but leaving blank if not populated 1

Top