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