Sigma Squared
Lexington, KY, USA
614-973-9100
Follow on:
Linkedin-in Twitter Youtube

text

LOWER

  • May 31, 2023
Definition: LOWER is a function that converts all uppercase letters in a text string to lowercase. Syntax: =LOWER(text) Situation: This formula is appropriate when you need to convert...
Read More

MID

  • May 31, 2023
Definition: MID is a function that returns a specified number of characters from the middle of a text string. Syntax: =MID(text, start_num, num_chars) Situation: This formula is appropriate...
Read More

HYPERLINK

  • May 31, 2023
Definition: HYPERLINK is a function that creates a hyperlink to a specified location. Syntax: =HYPERLINK(link_location, [friendly_name]) Situation: This formula is suitable when you need to create a hyperlink...
Read More

FIXED

  • May 31, 2023
Definition: FIXED is a function that rounds a number to a specified number of decimal places and formats the result with commas and a currency symbol. Syntax: =FIXED(number,...
Read More

EXACT

  • May 31, 2023
Definition: EXACT is a function that compares two text strings and returns TRUE if they are identical, otherwise it returns FALSE. Syntax: =EXACT(text1, text2) Situation: This formula is...
Read More

FIND

  • May 31, 2023
Definition: FIND is a function that searches for a specified text string within another text string, and returns the starting position of the first occurrence. Syntax: =FIND(find_text, within_text,...
Read More

FINDB

  • May 31, 2023
Definition: FINDB is a function that searches for a specified text string within another text string, and returns the starting position of the first occurrence, counting each double-byte...
Read More

DOLLAR

  • May 31, 2023
Definition: DOLLAR is a function that converts a number to text with a currency format. Syntax: =DOLLAR(number, [decimals]) Situation: This formula is suitable when you need to convert...
Read More

CHAR

  • May 31, 2023
Definition: CHAR is a function that returns the character specified by a number. Syntax: =CHAR(number) Situation: This formula is suitable when you need to convert a number to...
Read More

CLEAN

  • May 31, 2023
Definition: CLEAN is a function that removes all non-printable characters from a string. Syntax: =CLEAN(text) Situation: This formula is suitable when you need to remove non-printable characters, such...
Read More