Does Excel convert lowercase letters to uppercase letters in a formula?

Answer 1

The names of functions and cell references will be converted to uppercase. Regular text that may be used in a function will not be changed. So if you typed the first version below, Excel would convert it into the second version:

=find("a",b5)

=FIND("a",B5)

--

To change from lower to upper case - EXAMPLE If the text to be changed is in B2 then in a cell preferably next to it place =UPPER(B2) the text in cell A2 will now be all uppercase. do this with each cell by copying the formula down for instance and this will change the case in the "B" Column to uppercase in the "A" column. However, you now have 2 columns with the same text , one in upper case the other in lower (its duplicated) if you want to copy the uppercase to replace the lowercase simply select all those cells in the "A" Column and paste in to the "B" column as "value" - Value option is found in the paste menu by right clicking the target cell. This can replace a huge of cells in one go -

For lower case use =LOWER (cell reference) or for names all in one cell that need to be fist letter capitalised on each name use =PROPER(B2)

Answer 2

Yes