It was supposed to be A2 (typing error).

And yep. It only combines two things at once. But when you get to B2000,
everything is combined.

metaltecks wrote:

this only copies the next 2 entries each time.
is the formula supposed to be =B1&", "&As or A2?

"Dave Peterson" wrote:

Insert a new column B.
Put this in B1:
=A1
Put one of these in B2:
=B1&A2
or
=B1&" "&A2
or
=B1&", "&As

And drag down the column.

Each cell will contain more and more of your data.

Copy B2000 and paste into Notepad.

Depending on how much text is in each cell, it might work.

metaltecks wrote:

I have a spreadsheet that contains a total of 2000 lines of data.
I want to be able to copy the first cell, A1-a2000, and put them in notepad
program. The only problem is that when I copy them, it copies them exactly,
inside the cells. How can I get rid of the cells or if you know of an easier
way to do this.

Thank you

--

Dave Peterson


--

Dave Peterson