Why is there a box symbol at the end of my street addresses in on.

G

Gord Dibben

sara

The boxes are probably carriage returns.

In Excel, try Edit>Replace

what: ALT + 0010(on numpad)
with: space(or nothing)

OR ALT + 0013

If this doesn't work, post back. There are other avenues of approach.

Gord Dibben Excel MVP
 
Top