Excel Formulas Here, you can find examples that use formulas. Most of them also use functions that are listed next to them. Count Count cells that are not blank. COUNTA COUNTIF Text Remove leading and trailing spaces CHAR CLEAN SUBSTITUTE TRIM Capitalize the first letter LEFT LOWER PROPER REPLACE UPPER Add leading zeros IF CONCATENATE TEXT Remove leading zeros FIND LEFT LEN RIGHT SUBSTITUTE TEXT VALUE Rows and Columns Get column and row number ROW COLUMN Remove blank rows COUNTA Highlight duplicate rows CONCATENATE COUNTIF Date and Time Timestamp IF NOW TODAY Convert number to date DATE TEXT Other Sumproduct SUMPRODUCT IF statement AND IF ISNUMBER OR