I faced that PROPER function does not convert text properly. FOr example,

Your text is: ThIs IS a rAbbIt.

It will convert like this: This Is A Rabbit.

If you notice, it sets all first letter after every space in upper case. If you look at the proper sentence, it should look like this -

-- This is a rabbit.

Please help me with solution.

Thanks,
praveen
add on fb - royalstone.r