Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace CR character in text pasted from Access database
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Formatting text in cell (character by character) | Excel Discussion (Misc queries) | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
Exported from Access - text has a character before it | Excel Discussion (Misc queries) | |||
Excel find/replace should allow values to be pasted in. | Excel Worksheet Functions | |||
I want to replace the first character in a column of text | Excel Programming |