View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
philr philr is offline
external usenet poster
 
Posts: 10
Default import long Word document

Using Office 2003.
Daily we dictate patients notes and the secretary creates a long Word
document including the ~10 patient as one long file. (This makes it easier
for the docs to edit.) Each patient note is ~3pages w/hard page breaks
between patients.

I now have a need to upload these files into an Electronic Medical Record
system but I need to break out the separate pt notes into Excel cells, one
patient note per cell.

When I Copy|Paste the entire document each hard paragraph puts text into a
separate cell. Is there a way to massage the data quickly to place say 10 pt
notes into 10 vertical cells? I've tried "Replacing" hard paragraphs with
unique text but I can't reverse the process in Excel to replace the hard
paragraphs.

Does Office 2007 have a better feature for this?

Thanks,
philr