Require help with PROPER function in excel
 

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

Require help with PROPER function in excel
 

Hi,

Am Tue, 12 Jul 2016 05:37:41 -0700 (PDT) schrieb
:

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.

PROPER converts /each/ word of your string. Try:

=PROPER(LEFT(A1,FIND(" ",A1)))&LOWER(MID(A1,FIND(" ",A1)+1,99))


Regards
Claus B.
--
Windows10
Office 2016