TOUPPER

Convert a string to all upper case characters

This function is used to convert the text inside the brackets into upper case characters. The format required is

=TOUPPER (text)

So to convert a string BaseDoor to all upper case you would enter

=TOUPPER(BaseDoor) would give BASEDOOR

Any numbers in a string remain unchanged.

=TOUPPER(Melchip18mm) would give MELCHIP18MM

Any text containing spaces needs to be contained within "".