ADDRESS,
ROW,
ROWS,
COLUMN,
COLUMNS,
HYPERLINK,
put full reference address in the cell,
row number,
column number,
count of rows,
count of columns,
put hyperlink in excel
DATE,
DATEVALUE,
TEXT,
DAY,
DAYS
DAYS360,
EDATE,
EOMONTH,
get a code of date,
excel date code,
mac date code,
convert date code to date,
difference days between two dates,
add month to existing date
Numbervalue,
proper,
replace,
rept, right, how to extract last name from full name,
change text into numeric,
Change text to proper case,
Repalce text with new text,
repeat text on given number of time,
get certain length of right text from text,
how to build text formulas
FIND,
FIXED, LEFT, RIGHT, MID, LEN,
LOWER, UPPER, PROPER, SEARCH A TEXT WITH IN TEXT,
Make a number in round figure, get a certain left text from text,
get a certain right text from text, get a certain text from mid of text, get lenghth of text, text in lower case, text in upper case,
text in proper case,
bahttext,
CHAR,
CLEAN,
CODE,
CONCATENATE,
DOLLER,
EXACT,
ASCII CODE,
CHANGE ASCII TO CHAR,
CHANGE CHAR TO ASCII,
REMOVE NONPRINTABLE CHAR,
Add strings or text,
matching the text,
put doller sign & fix decimal point
