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

text

CODE

  • May 31, 2023
Definition: CODE is a function that returns the ASCII code of the first character in a text string. Syntax: =CODE(text) Situation: This formula is suitable when you need...
Read More

BAHTTEXT

  • May 31, 2023
Definition: BAHTTEXT is a function that converts a number to Thai text. Syntax: =BAHTTEXT(number) Situation: This formula is suitable when you need to convert a number to Thai...
Read More

CONCATENATE

  • May 26, 2023
The CONCATENATE formula is used to combine text from multiple cells into one cell. To use the CONCATENATE formula, select the cell where you want the result to...
Read More

LEFT

  • May 26, 2023
The LEFT formula is used to extract a specified number of characters from the beginning of a cell. To use the LEFT formula, select the cell where you...
Read More

RIGHT

  • May 26, 2023
The RIGHT formula is used to extract a specified number of characters from the end of a cell. To use the RIGHT formula, select the cell where you...
Read More

TRIM

  • May 26, 2023
The TRIM formula is used to remove leading and trailing spaces from a cell. To use the TRIM formula, select the cell where you want the result to...
Read More