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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Why is there a box symbol at the end of my street addresses in on. (https://www.excelbanter.com/excel-discussion-misc-queries/1171-why-there-box-symbol-end-my-street-addresses.html)

sarahhutch89

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

Frank Kabel

Hi
post your question as body of the message

--
Regards
Frank Kabel
Frankfurt, Germany

"sarahhutch89" schrieb im
Newsbeitrag ...

Gord Dibben

sara

The boxes are probably carriage returns.

In Excel, try EditReplace

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

On Fri, 3 Dec 2004 09:13:03 -0800, sarahhutch89
wrote:

All times are GMT +1. The time now is 10:40 AM.