Writing multiple formulas in one.

[dpilkington]

Is there a way to write multiple formulas in one.
example: I want change CHEVRON, INC. to proper case and remove th
"," and replace it with a space.

Currently I have to write 2 formulas. =proper(A1) then copy an
pastespecial.
Then write =substitute(A1,","," ",) then copy and pastespecial again.

Is there a way to write something like
=PROPER(A1,=SUBSTITUTE(A1,","," ",))

so it will do it all at one time?

Thanks in advance

 

[fogbom]

Have you tried =PROPER(SUBSTITUTE(A1,","," ",))

 

[Arvi Laanemets]

Hi


=PROPER(SUBSTITUTE(A1,","," ",))

 

[Jason Morin]

=PROPER(SUBSTITUTE(A1,","," "))

HTH
Jason
Atlanta, GA

 

[Peo Sjoblom]

One way

=PROPER(SUBSTITUTE(A1,","," "))

 

[dpilkington]

Thanks to all.

When I ran the example you showed me it gave me an #VALUE error but yo
did put me on the right track. I tried:

=SUBSTITUTE((PROPER(A8)),","," ")

and it worked.

Thanks everyone

 

[dpilkington]

Thanks to all.

When I ran the example you showed me it gave me an #VALUE error but you
did put me on the right track. I tried:

=SUBSTITUTE((PROPER(A8)),","," ")

and it worked.

Thanks everyone.

 

[Bob]

Here is the answer:

=PROPER(SUBSTITUTE(A1,","," "))