Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing case
Is there a function that will take all caps and change it into sentance
format, or take all lower case and change it into sentance format ? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing case
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing case
I don't think the PROPER function's output would be considered "sentence format"... I image that format to be first letter of sentence upper case and the rest lower case (unless there is a proper name in the middle somewhere).
-- Rick (MVP - Excel) "Liliana" wrote in message .16... ?B?RGluZ2JhdGljdXMtTWF4aW11cw==?= <Dingbaticus- wrote in news:08ED6C2A-F74F-49B1-99A6- : Is there a function that will take all caps and change it into sentance format, or take all lower case and change it into sentance format ? The proper() function should do the trick. =Proper(A1) -- Lil |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing case
If we are talking a single sentence (with no proper nouns or name in the middle anywhere), you can do this...
=UPPER(LEFT(A1))&LOWER(MID(A1,2,LEN(A1))) If you are talking about multiple sentences in a single cell, well, then a formula starts to get complicated since sentences can end in periods, question marks and exclamation marks. -- Rick (MVP - Excel) "Dingbaticus-Maximus" wrote in message ... Is there a function that will take all caps and change it into sentance format, or take all lower case and change it into sentance format ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing from upper case to lower case | Excel Discussion (Misc queries) | |||
Changing multiple cell text from lower case to upper case | Excel Discussion (Misc queries) | |||
Changing file in all upper case to upper and lower case | Excel Discussion (Misc queries) | |||
Changing Upper case to Proper Case | Excel Worksheet Functions | |||
changing lower case to upper case | Excel Discussion (Misc queries) |