How can I replace spaces in text cells (excel) with underscores?

I've tried searching for " " and replacing it with _ but excel doesn't find
any spaces with " ".

use "~ " (tilde space - no quotes

HTH
--
AP

"JB2006" <[email protected]> a écrit dans le message de
news:[email protected]...
> I've tried searching for " " and replacing it with _ but excel doesn't
find
> any spaces with " ".
>

That worked well, many thanks!