LEFT(): LEFT([Product Name],3) : Leftmost N characters

RIGHT(): RIGHT([Category],2) : Rightmost N chars

MID(): MID([SKU],2,4) : Substring

LEN(): LEN([State]) : String length

LOWER(): LOWER([City]) : Lowercase

UPPER(): UPPER([City]) : Uppercase

TRIM(): TRIM([Ship Mode]) : Remove leading/trailing spaces

REPLACE(): REPLACE([Phone],'-','') : Substitute text

SPLIT(): SPLIT([Email],'@',1) : Split string on delimiter

FIND(): FIND([Email],'@') : Position of substring

CONTAINS(): CONTAINS([Comment],'urgent') : Boolean contains check

STARTSWITH(): STARTSWITH([City],'New') : Prefix check

ENDSWITH(): ENDSWITH([City],'ville') : Suffix check

ASCII(): ASCII('A') : ASCII code of char

CHAR(): CHAR(65) : Character from code

STR(): STR([Order ID]) : Cast number to string

SPACE(): SPACE(5) : Return N spaces

URLENCODE(): URLENCODE([URL]) : Encode special URL chars