Excel Text Functions

FUNCTIONSYNTAX
CHARCHAR(number)
CLEANCLEAN(text)
CODECODE(text)
CONCATCONCAT(text1, [text2], ...)
CONCATENATECONCATENATE(text1,text2,...)
DOLLARDOLLAR(number,decimals)
EXACTEXACT(text1,text2)
FINDFIND(find_text, within_text, [start_num])
LEFTLEFT(text,num_chars)
LENLEN(text)
LOWERLOWER(text)
MIDMID(text,start_num,num_chars)
PROPERPROPER(text)
REPLACEREPLACE(old_text,start_num,num_chars,new_text)
REPTREPT(text,number_times)
RIGHTRIGHT(text,num_chars)
SEARCHSEARCH(find_text,within_text,start_num)
SUBSTITUTESUBSTITUTE(text,old_text,new_text,instance_num)
TEXTTEXT(value,format_text)
TEXTAFTERTEXTAFTER(text,delimiter,[instance_num], [match_mode], [match_end], [if_not_found])
TEXTBEFORETEXTBEFORE(text,delimiter,[instance_num], [match_mode], [match_end], [if_not_found])
TEXTSPLITTEXTSPLIT(text,col_delimiter,[row_delimiter],[ignore_empty], [match_mode], [pad_with])
TEXTJOINTEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)
TRIMTRIM(text)
UPPERUPPER(text)
VALUEVALUE(text)