Skip to main content
Advanced Excel Formulas

Excel Formulas – Clean Function Removes Nonprintable Char

Text Formulas – Clean Function What Does It Do – Clean Function? This function removes any nonprintable characters from text. These nonprinting characters are often found in data which has been imported from other systems such as database imports from mainframes. Syntax =CLEAN(TextToBeCleaned) Formatting No special formatting is needed. The result will show as normal text. […]

Read More

Advanced Excel Formulas

Advanced Excel Formulas – DCOUNTA Function Description With Example

Count the number of products of a particular Brand. Criteria Range Is E23:E24 DATABASE FORMULA – DCOUNTA Function What Does It Do ? This function examines a list of information and counts the non blank cells in a specified column. It counts values and text items, but blank cells are ignored. Syntax =DCOUNTA(DatabaseRange,FieldName,CriteriaRange) Description For […]

Read More