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

[JB2006]

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

[Ardus Petus]

use "~ " (tilde space - no quotes

HTH
--
AP

"JB2006" <JB2006@discussions.microsoft.com> a écrit dans le message de
news:481EFE49-E0C8-431F-8B4D-8BB9618EAF26@microsoft.com...
> I've tried searching for " " and replacing it with _ but excel doesn't
find
> any spaces with " ".
>

[JB2006]

That worked well, many thanks!