Getting rid of those pesky white boxes...
 

Group,

I imported some data into Excel 2003. Some of the records contained "memo"
fields, which contained long text entries. Inside these text entries are
little white boxes (hard retrurns in the originating program), which, when
copied and pasted into MS Word, turn into paragraph symbols. I want to remove
them from Excel but I can't find a matching symbol to use in the search and
replace process.
Any ideas?
TIA,
Jeff

Getting rid of those pesky white boxes...
 

Jeff

Probably 0010 linefeeds.

Try EditReplace

What: CTRL + j

With: leave blank or enter a space


Gord Dibben MS Excel MVP

On Thu, 6 Dec 2007 14:38:02 -0800, Jeff Stouse
wrote:

Group,

I imported some data into Excel 2003. Some of the records contained "memo"
fields, which contained long text entries. Inside these text entries are
little white boxes (hard retrurns in the originating program), which, when
copied and pasted into MS Word, turn into paragraph symbols. I want to remove
them from Excel but I can't find a matching symbol to use in the search and
replace process.
Any ideas?
TIA,
Jeff