| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trying to replace 2 spaces with 1
You may have Non-Breaking Spaces in the cell. You can check with the Code() function
Look here for code to remove them: http://www.mvps.org/dmcritchie/excel/join.htm#trimall -- Kind regards, Niek Otten Microsoft MVP - Excel "mgm" wrote in message ... | Is there a way to search and replace within a column where there are 2 | spaces present? When I search for " " (no quotes) it says cannot be found. | | Thanks! | mgm | | |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
trying to replace 2 spaces with 1
BTW, the TRIM() function reduces multiple spaces to single ones (and removes leading and trailing spaces)
-- Kind regards, Niek Otten Microsoft MVP - Excel "Niek Otten" wrote in message ... | You may have Non-Breaking Spaces in the cell. You can check with the Code() function | Look here for code to remove them: | | http://www.mvps.org/dmcritchie/excel/join.htm#trimall | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | | "mgm" wrote in message ... || Is there a way to search and replace within a column where there are 2 || spaces present? When I search for " " (no quotes) it says cannot be found. || || Thanks! || mgm || || | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FIND TAB, Replace with Spaces (3) or ... | Excel Discussion (Misc queries) | |||
| Replace double spaces with Hard return | Excel Worksheet Functions | |||
| Excel: replace all 2 spaces to FF/LR in column of text | Excel Discussion (Misc queries) | |||
| How can I replace spaces in text cells (excel) with underscores? | New Users to Excel | |||
| How can I replace zeros with blank spaces during calculations plea | Excel Worksheet Functions | |||
Hybrid Mode
