I'm trying to export data from a database management package to Excel. I can create a text file containing the data but data cells which contain carriage returns won't import properly into Excel. I can change each CR to a text string like "#$#" and I then want a VBA macro which changes each "#$#" back to a CR. A CR in a cell in Excel on a Mac is 'control-option-enter'. How do I weave that into a replacement string?
Bookmarks