Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 169
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 - Formatting text in cell (character by character) TomC Excel Discussion (Misc queries) 0 January 29th 10 07:25 PM
Update Excel Database via Access Main Database with a script Finnbar New Users to Excel 2 November 3rd 08 07:24 PM
Exported from Access - text has a character before it Brian Excel Discussion (Misc queries) 0 January 31st 08 06:22 PM
Excel find/replace should allow values to be pasted in. belohls Excel Worksheet Functions 1 June 16th 06 09:54 AM
I want to replace the first character in a column of text Biredndra Excel Programming 5 October 28th 05 09:38 PM


All times are GMT +1. The time now is 12:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"