Excel formula to start with upper case after dot

[Faridwahidi]

Hi,

Anyone can help me to create excel formula to start with uppercase after "dot" regardless number of dot in sentences


Here is the example.
Adam is a Football player. He is a great player. Many of big club would like to sign him. He has won many trophies

[Glenn Kennedy]

=Proper(A1), assuming your data are in A1. Is there any reason why football has to have a capital?

[Faridwahidi]

Hi Kennedy,

I know PROPER but it would make upper case for all words not only "AFTER DOT" . As for Football is my fault. supposed to be lower case because of not after dot.


PROPER would make it like this
Adam Is A Football Player. He Is A Great Player. Many Of Big Club Would Like To Sign Him. He Has Won Many Trophies

I want like this
Adam is a football player. He is a great player. Many of big club would like to sign him. He has won many trophies


The above only sample and I want to make it applicable for unlimited number of "Dot"

[Glenn Kennedy]

Sorry - much more complicated that I thought at a quick read. I'll have a think. Not easy, i suspect...

[Faridwahidi]

does it means that Excel have no function do like this?

If formula cannot, will Macro do that? Since you are a Forum Expert, please advise me

[Debraj Roy]

My Funniest formula ever..

Please Login or Register  to view this content.

[Debraj Roy]

In case VBA allowed.. then..

Please Login or Register  to view this content.

PS: Do you really need those.. Dot(Space) ..!!

[Glenn Kennedy]

One enhancement to Debraj Roy's excellent solution - to put the spaces back in.

Please Login or Register  to view this content.

[Faridwahidi]

Hi Debraj & Kennedy,

Thanks a lot. I admit your ability & expertise.