Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Question
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Question
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Question
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Question
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Question
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Change List Based on Value Chosen in Another List | Excel Worksheet Functions | |||
Matching Lists Where List Size is Unequal | Excel Discussion (Misc queries) | |||
Inventory List Question | Excel Discussion (Misc queries) | |||
Custom List Question | Excel Discussion (Misc queries) | |||
Drop down list question | New Users to Excel |