| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nonbreaking Spaces in Excel @!*$#
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Nonbreaking Spaces in Excel @!*$#
On Sun, 6 May 2007 17:07:00 -0700, PlayingToAudienceOfOne
m wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Nonbreaking Spaces in Excel @!*$#
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 "PlayingToAudienceOfOne" wrote: 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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Nonbreaking Spaces in Excel @!*$#
This works--but only if you remember to use the NUMPAD to enter 0160--Thanks!
"Ron Coderre" wrote: 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 "PlayingToAudienceOfOne" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
| Embedding spaces in an Excel file ... | Excel Discussion (Misc queries) | |||
| spaces not recognized as spaces | Excel Worksheet Functions | |||
| when I tab in Excel - it move two spaces instead of one | Excel Worksheet Functions | |||
| remove spaces in text in excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
