Proper and Substitute

[superfb]

Hi all

How can I combine a Proper and substitute formula together?

 

[James006]

Hi,

Just encapsulate Substitute into Proper ...

=Proper(substitute(xx,yy,zz))

HTH

 

[Tim_Excel_]

=proper(substitute(,,))

 

[superfb]

I tried that. The proper formula doesn't work when combining

 

[Tim_Excel_]

Tested with

=PROPER(SUBSTITUTE("old McScrooge had a farm","McScrooge","McDonald"))

Works like a charm.

What is the complete formula you are trying to use?

 

[steve the fish]

Ill presume its the fact that substitute is case sensitive so you need to build that into your thoughts. This type of thing removes case then turns it into proper case afterwards:

=PROPER(SUBSTITUTE(LOWER("OLD McScrooge HAD A farm"),LOWER("mcscrOOGe"),"mcDOnald"))

 

[superfb]

I am removing the spaces in the text so proper doesn't operate as it sees it as one word

 

[Finalfight40]

I am removing the spaces in the text so proper doesn't operate as it sees it as one word

In that case how about:

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

 

[Tim_Excel_]

I am removing the spaces in the text so proper doesn't operate as it sees it as one word

This is exactly why you have to include the formula/code you're using together with an explanation of what you are trying to accomplish

Finalfight40's formula will do the job for you.