Each guide answers the Excel question completely and honestly, with copyable formulas and worked examples, then one short section shows the same formula running in Wisegrid's shared grid. Every Wisegrid claim is verified against the shipped 118-function engine before it is published.
Remove or strip characters in Excel: SUBSTITUTE for specific characters, TRIM and CLEAN for spaces and junk, LEFT/RIGHT/MID to cut by position, FIND to cut at a delimiter, and TEXTBEFORE/TEXTAFTER where available. Copyable formulas with worked examples.
Read the guide →Count cells that contain specific text in Excel: COUNTIF with * wildcards, criteria from another cell, the case-sensitive SUMPRODUCT + ISNUMBER + FIND variant, and contains-X-and-Y counts with COUNTIFS. Copyable formulas with worked examples.
Read the guide →Want the whole function list at once? The formula cheat sheet covers 60+ common functions with runnable examples, and the formula converter translates a Smartsheet formula into the Wisegrid form.
Start your 7-day free trial, or migrate your Smartsheet workspace with one token.