Re: How do I replace a character with another?

Tech-Archive recommends: Fix windows errors by optimizing your registry

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!
>>
>>
>>


.

Quantcast