Maybe someone else can respond with the technical explanation ("ansi
characters . . .") of why this works, but here's my approach:

- In some unused cell, type two spaces
- Highlight what you just typed and press Ctrl-C to copy
- Open the Replace function and paste (Ctrl-V) into the "Find What" field
- Paste again into the "Replace With" field, then hit backspace to eliminate
one of the two spaces.

If you want to limit your Replace to just one column, highlight that column
before invoking the Replace function.

HTH

"mgm" wrote:

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