Thread
:
Require help with PROPER function in excel
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
Posts: 3,872
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
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch