D
Dale Fye
I have an Access subroutine that exports the results of a query to an Excel
spreadsheet. Some of the fields being exported are memo fields, so they can
get rather long, and some of these have imbedded carraige returns.
When I set the cells value to the text that is in one of these fields, the
carraige returns appear as little squares in the Excel spreadsheet. Anyone
know what this characters Ascii code is, and how to replace it with something
else in Excel that will not display but will wrap the text to the next line?
spreadsheet. Some of the fields being exported are memo fields, so they can
get rather long, and some of these have imbedded carraige returns.
When I set the cells value to the text that is in one of these fields, the
carraige returns appear as little squares in the Excel spreadsheet. Anyone
know what this characters Ascii code is, and how to replace it with something
else in Excel that will not display but will wrap the text to the next line?