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.