INFORMATICS

The Best

Excel convert letters from small to large

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

Excel convert letters from small to large

Conversions letters from lowercase to big we can make using UPPER.


UPPER function design:


= UPPER (marked cell)


If we want to express that small can be invisible for example. Create their second sheet which retrieves data from the first sheet and put the data in the selected column.

The construction of such functions are:


= Sheet1! UPPER ($ A1)


The data of the selected column will be converted to the data to a column in another sheet.

Search