Re: How do I replace a character with another?

Alright, well...before when I tried out that code I was doing it in regular
cells with no formulas. This time I was putting it in the right way on the
cells with formulas, and it doesn't work. Any way to work around this?
--
-----
MosesX8
I've got questions, you've got answers!


"Bill Kuunders" wrote:

> 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" <MosesX8@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:B56114AE-E7E5-4714-8B33-721EEFDEF0A1@xxxxxxxxxxxxxxxx
> > 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" <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!
> >>
> >>
> >>
>
>
>
.