Posted to microsoft.public.excel.programming

AYPCN

external usenet poster

Posts: 10

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Concatenate	SJT	Excel Discussion (Misc queries)	7	February 19th 10 12:26 AM
Concatenate	Mac8128	Excel Worksheet Functions	3	March 26th 09 09:17 PM
CONCATENATE	How to get commas in the #'s of concaten	Excel Worksheet Functions	4	March 4th 09 01:39 AM
Concatenate	RChicken	Excel Discussion (Misc queries)	2	July 11th 06 03:00 PM
I know how to concatenate ,can one de-concatenate to split date?	QUICK BOOKS PROBLEM-	New Users to Excel	1	July 26th 05 05:07 PM

All times are GMT +1. The time now is 04:05 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us