Nonbreaking Spaces in Excel @!*$#

[Guest]

Does anyone know how to get rid of nonbreaking spaces in Excel? Search and
Replace does not work in Excel and the sort function does not work properly
with these pesky nonbreaking spaces. Help!

 

[Ron Rosenfeld]

Does anyone know how to get rid of nonbreaking spaces in Excel? Search and
Replace does not work in Excel and the sort function does not work properly
with these pesky nonbreaking spaces. Help!

=substitute(a1,char(160),"")

--ron

 

[Guest]

Try this to remove them:

<Edit><Replace>
Find What: [Alt]+0160.......(Hold down [Alt]…type 0160…release [Alt])
Replace with: (leave this blank)
Click [Replace All]

0160 is the ASCII code for the non-breaking space character

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

This works--but only if you remember to use the NUMPAD to enter 0160--Thanks!

Try this to remove them:

<Edit><Replace>
Find What: [Alt]+0160.......(Hold down [Alt]…type 0160…release [Alt])
Replace with: (leave this blank)
Click [Replace All]

0160 is the ASCII code for the non-breaking space character

Does that help?
***********
Regards,
Ron

XL2002, WinXP

Does anyone know how to get rid of nonbreaking spaces in Excel? Search and
Replace does not work in Excel and the sort function does not work properly
with these pesky nonbreaking spaces. Help!