Pasting from Notepad

[Guest]

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.

 

[Peo Sjoblom]

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)