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
datatext to columns, then you can select a delimiter or manually put that
in

--
Regards,

Peo Sjoblom

(No private emails please)


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