OK, What I’ve got is a Word 2000 document that I need to import into Excel 2000. Some lines in Word are broken up by manual line breaks (^l) and some by carriage returns (^p). I want the lines with line breaks at the end to all show up in a single Excel cell, each on its own line within the cell (normally created in Excel by using ALT+ENTER). The lines with paragraph marks will indicate a new cell in Excel (it normally does this anyway). The resulting Excel worksheet will only be 1 column wide.
I’ve thought about trying to perform some sort of find/replace in Word to replace line breaks with the character code for ALT+ENTER and then doing a copy/paste or import, but I don’t know the code to use or if this is even possible.
Any suggestions?
Mark
(I’m cross-posting this message to the Excel forum.)
