Menu

Require help with PROPER function in excel

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.worksheet.functions

Claus Busch Claus Busch is offline

Claus Busch is offline

external usenet poster

Posts: 3,872

Default

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
formulas/function require (2)	craig@help	Excel Worksheet Functions	5	July 14th 06 12:29 PM
CountIf Function - require range of criterea	John F	Excel Worksheet Functions	10	April 27th 05 10:55 PM
"proper" function excel wksht	CajnBred	Excel Worksheet Functions	2	April 12th 05 11:47 PM
PROPER function	MISTY66	Excel Worksheet Functions	1	March 3rd 05 10:16 PM
How do I use the PROPER function?	kp	Excel Discussion (Misc queries)	3	December 30th 04 01:44 PM

All times are GMT +1. The time now is 06:37 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement