Getting rid of those pesky white boxes...

  • Thread starter Thread starter Jeff Stouse
  • Start date Start date
J

Jeff Stouse

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
 
Jeff

Probably 0010 linefeeds.

Try Edit>Replace

What: CTRL + j

With: leave blank or enter a space


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I get rid of symbols that download in data from web 1
Using replace to get rid of paragraph return character 11
"anchor symbol"-how to get rid of 6
Pasting mutiple paragraph text into a single cell 2
Replacing Wierd Charactures 3
Restoring line breaks in memo field 1
Find and Replace unwanted symbol 6
Remove Carriage Return symbols from data 2

Back
Top