Other Functions
PROPER(text): Capitalizes the first letter in each word of a text value.
Example: =PROPER(“hello world”) returns “Hello World”.
LOWER(text): Converts text to lowercase.
Example: =LOWER(“Hello World”) returns “hello world”.
UPPER(text): Converts text to uppercase.
Example: =UPPER(“Hello World”) returns “HELLO WORLD”.
TEXT(value, format_text): Formats a number and converts it to text.
Example: =TEXT(1234, “$#,##0.00”) returns “$1,234.00”.
HYPERLINK(link_location, [friendly_name]): Creates a clickable hyperlink.
Example: =HYPERLINK(“www.example.com”, “Visit Example”).
For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com