Hi.
I have to track data from a huge and old report that when copied and pasted
into excel copies in one column. Is there something I can create- a template,
form, macro- something that when I paste the data it puts in a usable format
to create charts etc.
I appreciate any help!

Is there some delimiter between the fileds in the copied data (comma, tab
etc)? If so, you can use DataText to Columns.
If not, is there a way to export the data from the old database with a
suitable delimiter?

--
Ian
--
"Scared CO-OP :)" wrote in message
...
Hi.
I have to track data from a huge and old report that when copied and
pasted
into excel copies in one column. Is there something I can create- a
template,
form, macro- something that when I paste the data it puts in a usable
format
to create charts etc.
I appreciate any help!