Interesting suggestion Dave but I'd like to stretch you a bit.

I was hopeing for a solution where I didn't have to do lots of cut and
paste. I have several hundred Word Documents with about 10 patient dictations
in each. Each patient dictation is divided by a hard page break. To upload
properly into the Database I need each dictation in a separate cell (plus
other separate key field items) in a column. (They are not in tables.)

If I copy/paste the 10 patients into the formula bar the page breaks are not
recognized. If I paste into the cell the CR aren't recognized the way I need.
I've tried the replace $$$$$ you've suggested but can't get Excel to
cooperate by replacing CR for the $$$$$.

1 - my campus gets a great price for MSOffice 2007 and I can get that if it
will solve my dilemma easily. If yes, no problem.
2 - A macro may solve my dilemma if I use your $$$$$ method and use a CR in
place of a hard page break. Would I just drop in this macro and assign it a
name? I presume from my limited knowledge of macros that in AfterStr = " "
'or chr(10) 'for alt enter I need to get rid of the " " and just use chr(10)?

Thanks,
philr