Hi,


I've been asked to convert the attached word document to an excel spreadsheet based on the cells in the word doc. I've been trying to do this for the last couple of days without any success, really appreciate any help you can give.

Thanks
David

Attached Files

memp-system-action.doc (345.0 KB, 12 views)

There's nothing about your attachment that suggests the table can't be converted to Excel by simply copying the entire table and pasting it into Excel. The only complication you might have is that some of your table's cells contain paragraph breaks, which will result in extra rows being created in Excel. If you don't want that, replace the paragraph breaks (using Find/Replace in Word) with something else (e.g. |) before copying. Then, after pasting into Excel, replace that 'something else' (using Find/Replace in Excel) with line breaks.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks for your help Paul,
I was ignorant about replacing the paragraph symbol which obviously was my problem.
This is the beauty of internet you can ask the whole world.

Thank you
David