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

text

UNICHAR

  • May 31, 2023
Definition: The UNICHAR function in Excel is used to return the Unicode character that corresponds to a number. Syntax: ==UNICHAR(number). Situation: This formula is appropriate in situations where...
Read More

UNICODE

  • May 31, 2023
Definition: The UNICODE function in Excel is used to return the Unicode code of a character. Syntax: ==UNICODE(text). Situation: This formula is appropriate in situations where you need...
Read More

UPPER

  • May 31, 2023
Definition: The UPPER function in Excel is used to convert text to uppercase. Syntax: ==UPPER(text). Situation: This formula is appropriate in situations where you need to convert text...
Read More

VALUE

  • May 31, 2023
Definition: The VALUE function in Excel is used to convert a text string that represents a number to a numerical value that Excel can recognize as a number....
Read More

T

  • May 31, 2023
Definition: The T function in Excel is used to convert text to a number. Syntax: ==T(value). Situation: This formula is appropriate in situations where you need to convert...
Read More

TEXT

  • May 31, 2023
Definition: The TEXT function in Excel is used to convert a value to text in a specific format. Syntax: ==TEXT(value, format_text). Situation: This formula is appropriate in situations...
Read More

SUBSTITUTE

  • May 31, 2023
Definition: The SUBSTITUTE function in Excel is used to replace a part of a text string with a different text string. Syntax: ==SUBSTITUTE(text, old_text, new_text, [instance_num]). Situation: This...
Read More

N

  • May 31, 2023
Definition: N is a function that returns a value converted to a number. Syntax: =N(value) Situation: This formula is appropriate when you need to convert a value to...
Read More

JIS

  • May 31, 2023
Definition: JIS is a function that converts a double-byte character set (DBCS) code to a single-byte character set (SBCS) code. Syntax: =JIS(text) Situation: This formula is appropriate when...
Read More

LEN

  • May 31, 2023
Definition: LEN is a function that returns the number of characters in a text string. Syntax: =LEN(text) Situation: This formula is appropriate when you need to find the...
Read More