List Question

[metaltecks]

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

[Bernard Liengme]

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" <[email protected]> wrote in message
news:[email protected]...
>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

[metaltecks]

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" <[email protected]> wrote in message
> news:[email protected]...
> >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]

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

[metaltecks]

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]

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