Excel convert letters from small to large
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.