Writing multiple formulas in one.

  • Thread starter Thread starter dpilkington
  • Start date Start date
D

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
 
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
 
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.
 
Back
Top