List Question

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

How can this be? Notepad has no formatting other than fonts. So how can
Notepad get the cell borders?
Or do you mean you want the data not to be on separate lines but in a
continuous string?
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"metaltecks" wrote in message
...
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

Yes, I would like for it to be in a continous string, how can I do that?

"Bernard Liengme" wrote:

How can this be? Notepad has no formatting other than fonts. So how can
Notepad get the cell borders?
Or do you mean you want the data not to be on separate lines but in a
continuous string?
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"metaltecks" wrote in message
...
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

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

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

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