Thanks for the feed back.
and George's solution is great.
For more than one character you may have to use the macro again.
Just copy the code several times and change the item you want to replace.
etc

--
Greetings from New Zealand
Bill K

"MosesX8" wrote in message
...
Thanks! Worked perfect. What if I wanted to substitute multiple
characters?
In this case I want a space ( ), a colon (:), forward (/) and back slash
(\),
and a few more. It's basically any character that won't go into a
filename,
with an exception for the space. Thanks again!

And Bill, I tried out that code, and it works great, but the simple
substitute worked fine in my case.

"George Nicholson" wrote:

=SUBSTITUTE(C3," ",".")

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"MosesX8" wrote in message
...
In my spreadsheet I have the cells in column F referencing from cells
in
column C. The original content in the cells in column C have spaces in
them.
What I want to happen is have the cells in column E have all spaces ( )
replaced by periods (.). I know I can go to EditReplace, but the cells
are
often updated and would be much easier if I didn't have to replace them
every
time.

In cell C3:
A Stupid Example

In cell F3:
A.Stupid.Example

Thanks!