Thread: CONCATENATE
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
AYPCN AYPCN is offline
external usenet poster
 
Posts: 10
Default 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.