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
||
||
|
|