Getting rid of Carriage Return Characters after export

[Nefaria]

I'm constantly required to export data from Access to Excel for formatting and find it extremely difficult to remove the Chr(10) and Chr(13) codes from the imported data. A search and replace in Excel doesn't recognize the characters and I can find no 'quick' way of fixing this problem, is there a way of making sure the characters don't come across during an export (they appear as boxes in Excel) or is there code that I can use in Excel to search for and remove the carriage return characters?

[PEB]

If in your data in Access you have those symbols you can use the function:
Replace(My_field, chr(13), "") and everywhere in the field CHr(13) will be replaced with ""

But maybe this problem appears while exporting data to Excel? How do you export your data to Excel? Because when I use directly xls format for Excel 5-7 I don't have any problems! It's like in Access!

[jennyc]

Thanks, great tip - both of you, for telling me what the character numbers were that were replacing those carriage returns in the Access memo field, and for suggesting the replace() function.

I used the following nested replace in my query, it even worked around the results of my iif() function - to replace the multi-line characters with a "," and " " for a much smoother export.

eg: A query to pull the correct address from a record now contains this:
Mailing address: Replace(Replace(IIf[Address] Is Null,[address2],[address]),Chr(13),","),Chr(10)," ")

There are probably a number of permutations that would have worked in this situation. (like putting the "replace" within the iif - but I'd have had to do it for both fields then)! So thanks for the tip.