funny squares in excel

[msincome]

I have converted a data base to excel and in a lot of the text in the address column are small boxes. I guess these are from dashes or unknown characters in the text. Is there any way to get rid of them other than doing it manually.

Quentin

 

[MyExcel]

I think Clean Function can do it

=CLEAN(A1)

 

[Sandeep Warrier]

I have converted a data base to excel and in a lot of the text in the address column are small boxes. I guess these are from dashes or unknown characters in the text. Is there any way to get rid of them other than doing it manually.

Quentin

I think the squares denote a carriage return (alt+enter)
Copy one of the squares. Select your entire range. Press Ctrl+H. In the Find What section paste the square that you copied. In the Replace with section put in the character you want to replace the squares with (usually a space) and click on Replace All
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[pgc01]

Hi

Before erasing those characters format the cell with Wrap Text. They may be there to format the text.

 

[msincome]

Sandeep had it right. It was for carriage return.

One other question I have noticed a lot of duplicates records so whats the best way to clean them out.

Quentin