TEXT(value, format_text): Converts numbers/dates to text with specific formatting (e.g., TEXT(A1, "0.00") or TEXT(B1, "mm/dd/yy")).
LEFT(text, num_chars): Extracts characters from the left of a text string.
RIGHT(text, num_chars): Extracts characters from the right of a text string.
MID(text, start_num, num_chars): Extracts characters from the middle of a text string.
TRIM(text): Removes extra spaces from text (leading, trailing, and extra spaces between words).
PROPER(text): Capitalizes the first letter of each word.
UPPER(text): Converts text to all uppercase.
LOWER(text): Converts text to all lowercase.
LEN(text): Returns the number of characters in a text string.
CONCAT / &: Combines text strings (e.g., ="Hello " & A1 & "!").
=TEXT()
=VALUE()
=MID()
=LEFT()
=DATE(
MID(
A1,
FIND("/",A1)+1,
IND(
"/",
A1,
FIND("/",A1)+1
)-FIND("/",A1)-1
),
LEFT(
A1,
FIND("/",A1)-1
),
MID(
A1,
FIND("/",A1)+1,
FIND("/",A1,FIND("/",A1)+1)-FIND("/",A1)-1)
)
)
FIND function
LEFT function
MID function