| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
The proper() function makes sam's Sam'S.
The proper function incorrectly capitalizes the letter after an apostrophe.
Language US-EN 1033 |
|
#2
|
|||
|
|||
|
Actually, it's correct, if not what most people would want. Then again,
XL is not a word processor. As documented in Help: Proper Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters. In article , Josh Ross <Josh wrote: The proper function incorrectly capitalizes the letter after an apostrophe. |
|
#3
|
|||
|
|||
|
One way to trick it would be to use something like
=SUBSTITUTE(PROPER(SUBSTITUTE(A1,"'","zzz")),"zzz" ,"'") Regards, Peo Sjoblom "Josh Ross" wrote: The proper function incorrectly capitalizes the letter after an apostrophe. Language US-EN 1033 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
| How do I use the PROPER function? | Excel Discussion (Misc queries) | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
