Re: How do I replace a character with another?

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

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"MosesX8" <MosesX8@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2B16983F-399A-4FAE-9547-7749F87B460E@xxxxxxxxxxxxxxxx
> In my spread*** 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 Edit>Replace, 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!


.