![]() Make sure the AutoCorrect tab is displayed. Excel displays the AutoCorrect dialog box. If the word has no vowels, then the code assumes it's an acronym and converts the entire word to upper. In Excel 2010 and later versions display the File tab of the ribbon and then click Options.) Click Proofing at the left side of the dialog box. ![]() are considered word ending characters so that in both cases the S and the P will be converted to upper case.Īlso there's a list of special words that should be all caps, like "usa" my code will convert that to USA. For example "steve_pupel" or "steve.pupel". Here’s a rundown of what each of the options does: Correct TWo INitial CApitals: Changes a capitalized second letter in a word to a lowercase letter. There's a string variable which holds each character that could be considered a word ending. On the AutoCorrect tab of the AutoCorrect Options window, you’ll see some different capitalization settings towards the top of the tab. ![]() There are a couple nice features about the code. Then a the code loops through each array element and converts the first letter of each word to upper case. The basic technique is that there is a first function which breaks up a string into separate words and stores each word as an array element. I wrote a couple functions many years back to solve this exact problem.
0 Comments
Leave a Reply. |