Double spacing
 

Hi Everyone,

I have an Excel Spread Sheet with addresses, each address is in one cell and
each line of the address is separated by a [] [] (two squares).

How can I remove this spacing and replace with a coma?

Regards,

Anguel

Double spacing
 

Did you try copying one of those characters and placing in the Find What box
while doing a find/replace?

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"axissm" wrote in message
...
Hi Everyone,

I have an Excel Spread Sheet with addresses, each address is in one cell
and
each line of the address is separated by a [] [] (two squares).

How can I remove this spacing and replace with a coma?

Regards,

Anguel

Double spacing
 

Yes I did but with no luck.

Heeelp :-)

"Anne Troy" wrote:

Did you try copying one of those characters and placing in the Find What box
while doing a find/replace?

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"axissm" wrote in message
...
Hi Everyone,

I have an Excel Spread Sheet with addresses, each address is in one cell
and
each line of the address is separated by a [] [] (two squares).

How can I remove this spacing and replace with a coma?

Regards,

Anguel