Have a spreadsheet with address data that has been used for many years to produce mailing labels in Word 2000/2003. The address field in the spreadsheet has the address in one field (column) and the City/State are on new lines using the ALT-ENTER command within the cell. A sample of the cell contents is:
123 Avenue Road
Since upgrading to 2007, the Address line doesn't recognize the carriage return (or new line) and prints a special character. Also, I've tried text-to-column but cannot delimit on the carriage return (or new line).
Thoughts as to why/how to make this work?