Word Pad to Excel

[pulling my hair out]

I have a word pad document that I repeatedly place into excel (copy + paste)
and go through the steps of text-to-coulms, formatting the clomns, page
set-up, etc... Is there a way to create a template and apply it to the data
that is pasted into excel so it is always has the same column widths, page
set-up, formats, etc...?

Thanks

 

[Bob I]

Record a macro?

 

[James Silverton]

Bob wrote on Wed, 13 Aug 2008 12:33:45 -0500:

pulling my hair out wrote:

Record a macro?

It's not that hard to record a macro as you say and, even if does not
work perfectly the first time, a little editing will usually fix it. The
OP may not be aware that a lot of pros. use the record and edit method
in MS Word.
--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not