View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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
|
|