TOLOWER  

 

Convert a string to all lower case characters

 

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

 

=TOLOWER (text)

 

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

 

=TOLOWER(BaseDoor) would give basedoor

 

Any numbers in a string remain unchanged.

 

=TOLOWER(MELCHIP18MM) would give melchip18mm

 

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