I wouldn't paste into the formula bar for more than a couple.

But I _think_ that this would work.

Inside MSWord:
Change the paragraph marks (and soft returns) to $$$$$.
But then change the new page to a paragraph mark.

Then copy and paste into excel
The text separated by paragraph marks should go into different cells. The text
with $$$$$ will be seen as just plain old text and go into that giant cell.

I haven't tested this on xl2007. I wouldn't imagine that something this basic
(how excel sees paragraph marks) would change in any version--maybe some one
could test and post back.

And yep. Change the afterstr to a space character (" ") or an alt-enter
(chr(10) or even vblf) if you want a new line in that cell.

And read those notes by David McRitchie. It should help you install the macro
and show you how to run it.

If you have questions, post back.

Here's hoping that someone with xl2007 handy will test and post back with their
results.


philr wrote:

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

--

Dave Peterson