| Home |
| Search |
| Today's Posts |
|
#16
Posted to microsoft.public.excel.misc
|
|||
|
|||
change case
A bit annoying to see the same incorrect macro code over and over
again in these newsgroups in reply to questions already correctly answered and many of them more than five days old, and more than once in this thread. The answer to sentence case can be correctly seen Tushar Mehta's code previously mentioned in this thread. And making someone reply to a question everytime they invoke a macro for a single simple task is not efficient for productivity. A1: this is sentence number one. this is another sentence. so is this. -- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "PlayingToAudienceOfOne" m wrote in Case "S": ocell = UCase(Left(ocell.Text, 1)) & _ LCase(Right(ocell.Text, Len(ocell.Text) - 1)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change mixed case to upper case in Excel for all cells | Excel Discussion (Misc queries) | |||
| Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
| How do I change a column in Excel from upper case to lower case? | Excel Worksheet Functions | |||
| How do I change existing text from lower case to upper case | Excel Discussion (Misc queries) | |||
| How to use formula auditing to change upper case to Title Case. | Excel Worksheet Functions | |||
Threaded Mode
