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

JB2006 · Apr 20, 2006

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

Ardus Petus · Apr 20, 2006

use "~ " (tilde space - no quotes

HTH

JB2006 · Apr 20, 2006

That worked well, many thanks!