Pasting from Notepad

I have a report in notepad in .txt format. There is a variety of information
arrayed in a variety of tables in the text document. I know that I can paste
the information into excell and each row in the txt document will occupy a
single cell in excell. Is there any way to take that pasted information and
then break it out into multiple cells. I already know that if I put <tabs>
between the values that they will occupy seperate cells but there are a
goodly number of such report and several hundred records per report so a way
to automate this would be very welcome.

Example:

The Text document has A-B-C-D-E-F-G as a row of data. When pasted into
Excell I get A-B-C-D-E-F-G in a single cell. What I would like is to be able
to automate breaking that information out into multiple cells so that I have
<A><B><C><D><E>, etc... in seperate cells.

Open the file directly from excel will start the text import wizard AKA
data>text to columns, then you can select a delimiter or manually put that
in

--
Regards,

Peo Sjoblom

(No private emails please)


"Al" <Al@discussions.microsoft.com> wrote in message
news:7D023986-6E3E-49E5-A1A4-7FC2E8858310@microsoft.com...
>I have a report in notepad in .txt format. There is a variety of
>information
> arrayed in a variety of tables in the text document. I know that I can
> paste
> the information into excell and each row in the txt document will occupy a
> single cell in excell. Is there any way to take that pasted information
> and
> then break it out into multiple cells. I already know that if I put
> <tabs>
> between the values that they will occupy seperate cells but there are a
> goodly number of such report and several hundred records per report so a
> way
> to automate this would be very welcome.
>
> Example:
>
> The Text document has A-B-C-D-E-F-G as a row of data. When pasted into
> Excell I get A-B-C-D-E-F-G in a single cell. What I would like is to be
> able
> to automate breaking that information out into multiple cells so that I
> have
> <A><B><C><D><E>, etc... in seperate cells.