Formatting all-caps

Much people have requested modifications in VExtenso so that the generated text possesss the first letter all-caps, the following ones in small letters, or despite all are all-caps, or the first letter of each word in capital letter, etc.

Then, Excel possesss proper functions for this and if combined with the VExtenso function () they can produce the result desired.

Figure 1: Combining the VExtenso with other functions of Excel

To transform a text all-caps we can use the CAPITAL function (); to transform the first letter of each word into capital letter, we can use function PRI.MAIUSCULA (). Unhappyly function PRI.MAIUSCULA (), for being “perfect” and to make what she promises literally, it transforms until the preposition “of” into “Of”, and the conjunction “and” for “E”. To skirt this “problem” we will use the function TO SUBSTITUTE () of Excel, to change words “and” for “e”, and “Of” for “of”. These transformations are valid for the Portuguese Language. For other languages this solution will have to be adapted.

It sees as it would be the complete function:

=SUBSTITUIR (TO SUBSTITUTE (PRI.MAIÚSCULA (VExtenso (A1)); “E”; “e”); “Of”; “of”)

Figure 2: The combination of the functions

Important comment: For that they possess Excel in the version in English, the name of the functions will have to be modified stops:

PRI.MAIÚSCULA --> PROPER

CAPITAL LETTER     --> UPPER

TO SUBSTITUTE    --> SUBSTITUTE

For the translation of other functions it consults the VIRTUAL site DATE.