Prev: Top row of excel stays even in sorting
Next: How to undo overwrites?
From: Tom on 19 Apr 2010 03:56
Hi,

I want to select a bunch of text data separated by commas from a website,
use Windows copy command to copy and paste it into a worksheet in Notepad
and save it as a text file.
How can I do that? That's all.

In case you want to know further, I then can open the text file within
Excel as a comma delimited data and manipulate it as much as I like. Thanks
for any help.

TIA
Tom


From: Jacob Skaria on 19 Apr 2010 08:04
Hi Tom

--From 'Insert' menu select 'Object'
--Select 'Word Pad Document'
--Select 'Display As Icon' if you want..
--Edit,save etc; as you want

--
Jacob (MVP - Excel)


"Tom" wrote:

> Hi,
>
> I want to select a bunch of text data separated by commas from a website,
> use Windows copy command to copy and paste it into a worksheet in Notepad
> and save it as a text file.
> How can I do that? That's all.
>
> In case you want to know further, I then can open the text file within
> Excel as a comma delimited data and manipulate it as much as I like. Thanks
> for any help.
>
> TIA
> Tom
>
>
> .
>
From: Tom on 19 Apr 2010 19:01
That's interesting - a text document within Excel. However, I was looking
for a way to save the captured data as a csv file. In which case I wouldn't
have to save it as a text file first (under Windows) and then open it with
Excel. Thanks for your suggestion.

Jacob Skaria" <JacobSkaria(a)discussions.microsoft.com> wrote in message
news:B16BBEC4-1C78-45C1-A5AE-9DE16308C11C(a)microsoft.com...
> Hi Tom
>
> --From 'Insert' menu select 'Object'
> --Select 'Word Pad Document'
> --Select 'Display As Icon' if you want..
> --Edit,save etc; as you want
>
> --
> Jacob (MVP - Excel)
>
>
> "Tom" wrote:
>
>> Hi,
>>
>> I want to select a bunch of text data separated by commas from a website,
>> use Windows copy command to copy and paste it into a worksheet in Notepad
>> and save it as a text file.
>> How can I do that? That's all.
>>
>> In case you want to know further, I then can open the text file within
>> Excel as a comma delimited data and manipulate it as much as I like.
>> Thanks
>> for any help.
>>
>> TIA
>> Tom
>>
>>
>> .
>>


 | 
Pages: 1
Prev: Top row of excel stays even in sorting
Next: How to undo overwrites?