When scripting in Excel can you use notepad?

I'm looking to do some very basic things with Excel....need to copy a few lines of text and have the text outputted into particular format...example

inputted text is something like

Example 1: Name
Example 2: Address
Example 3: Phone

Outputted text

The *NAME* goes here and the *ADDRESS* goes here and finally the *PHONE* goes here.

Any idea on how I can do that using textpad?

Thanks

It's not clear what you mean, why use Notepad?

Do what? Attach an example - before & after

Okay how do I turn this:

Date&Time Call 1 - A: INFO GOES HERE

Spoke To 1 - A: INFO GOES HERE

Outcome 1 - A: INFO GOES HERE

Date&Time Call 2 - A: INFO GOES HERE

Spoke To 2 - A: INFO GOES HERE

Outcome 2 - A: INFO GOES HERE

Verified Contact Info for Provider A INFO GOES HERE

Sent By - A: INFO GOES HERE

Additional Information - A: INFO GOES HERE


INTO THIS



Facility/AP Name Situs NY [X] YES [X] NO
Spoke with: NAME
4/29/2010 at TIME, Call #1 [X] Live Body [X] Greeting [X] Busy [X] No answer - VM
4/29/2010 at TIME, Call #2 [x] Live Body [X] Greeting [X] Busy [X] No answer - VM

Verified Contact Info for AP/Facility [X] Yes [X] No
Request sent by [X] Mail [X] Fax
Additional Info: Chris Wheelous
===========================================================

Maybe someone else will take the time to create an example workbook 7 solution, I can't work with pictures.

Roy's suggestion is that you post a workbook with before and after examples.