Double spacing

[Guest]

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

 

[Anne Troy]

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

 

[Guest]

Yes I did but with no luck.

Heeelp

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

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