**Count** |

**Count cells equal to** | *COUNTIFSUMPRODUCTEXACT* |

**Count cells not equal to** | *COUNTIF* |

**Count cells equal to either x or y** | *COUNTIFSUMPRODUCTSUM* |

**Count cells equal to both x and y** | *COUNTIFS* |

**Count cells greater than or less than** | *COUNTIF* |

**Count number of cells between two values / dates** | *COUNTIFS* |

**Count number of cells not between two given numbers** | *COUNTIFSUMPRODUCT* |

**Count number of cells equals to one of many values** | *COUNTIFSUMPRODUCT* |

**Count number of cells not equal to many values** | *COUNTIFCOUNTASUMPRODUCT ISNAMATCH * |

**Count number of cells not equal to x or y** | *COUNTIFSSUMPRODUCT* |

**Count blank or nonblank cells** | *COUNTBLANKCOUNTIF* |

**Count cells that begin/end with specific text** | *COUNTIF* |

**Count cells that contain either x or y** | *SUMPRODUCTISNUMBERFIND* |

**Count cells that contain specific text with case sensitive** | *SUMPRODUCTISNUMBERFIND* |

**Count How Many Cells Contain Errors** | *SUMPRODUCTISNUMBERSUM* |

**Count number of cells contain numeric or non-numeric values** | *SUMPRODUCTISNUMBERNOTCOUNT* |

**Count number of cells that contain odd or even numbers ** | *SUMPRODUCTMOD* |

**Count number of cells that contain positive or negative values ** | *COUNTIF* |

**Count number of cells that contain specific number of characters ** | *COUNTIFSUMPRODUCTLENN* |

**Count Number Of Cells That Contain Specific Text ** | *COUNTIFSUMPRODUCTFINDISNUMBER* |

**Count the number of text cells** | *COUNTIFCOUNTIFS* |

**Count cells that do not contain errors** | *ISERRORSUMPRODUCTSUM* |

**Count cells that do not contain specific text** | *COUNTIFCOUNTIFS* |

**Count Number Of Cells That Do Not Contain Many Values** | *SUMMMULTISNUMBERTRANSPOSEROW* |

**Count Number Of Dates By Day Of Week** | *SUMSUMPRODUCTWEEKDAY* |

** Count Multiple Criteria With NOT Logic** | *SUMPRODUCTMATCH* |

** Count Numbers That Begin With A Specific Number ** | *SUMPRODUCTLEFT* |

**Count Occurrences Of Particular Text In Entire Excel Workbook ** | *SUMPRODUCTCOUNTIFINDIRECT* |

**Count Or Sum Only Whole Numbers ** | *SUMPRODUCT MOD* |

**Count Numbers Where The Nth Digit Equals To X** | *SUMPRODUCT MID* |

**Count cells that match two or more criteria** | *COUNTIFS* |

**Count matches between two columns ** | *SUMPRODUCT* |

**Count number of dates by year, month ** | *SUMPRODUCTYEARMONTH* |

**Count rows if meet internal criteria** | *SUMPRODUCT* |

**Count Rows If Meet Multiple Criteria** | *SUMPRODUCT* |

**Count All Matches / Duplicates Between Two Columns** | *SUMPRODUCTCOUNTIFCOUNTMATCHISNUMBER* |

**Count Number Of Rows That Contain Specific Values** | *SUMMMULTTRANSPOSECOLUMN* |

**Count Number Of Rows With Multiple OR Criteria** | *SUMPRODUCT* |

**Count Unique Numeric Values Based On Criteria** | *SUMFREQUENCYROWSUNIQUEFILTER* |

**Count Unique Numeric Values Or Dates In A Column** | *SUMFREQUENCYISNUMBERUNIQUECOUNTIFCOUNT* |

**Count Number Of Visible Rows In A Filtered List** | *SUBTOTAL* |

**Count Unique Values In A Range** | *SUMPRODUCTFREQUENCYMATCHROWCOUNTIF* |

**Count Unique Values With Criteria ** | *SUMFREQUENCYMATCHROWIF* |

**Count Visible Rows With Criteria** | *SUMPRODUCTSUBTOTALROWMIN* |

**Use COUNTIF On A Non-Contiguous Range** | *SUMCOUNTIFINDIRECT* |

**Countifs With OR Logic For Multiple Criteria ** | *SUMCOUNTIFSUMPRODUCTMATCH ISNUMBER* |

**Calculate Percentage Breakdown Of Items In A List ** | *COUNTIFCOUNTA* |

**Create A Summary Count By Month With COUNTIFS ** | *COUNTIFSEDATE* |

**Do Running Count Of Occurrence In A List ** | *COUNTIFIF* |

**Summary Count Of Non-Blank Categories ** | *COUNTIFS* |

**Sum** |

**3D sum or sumif across multiple worksheets** | *SUMSUMPRODUCTSUMIFINDIRECT* |

**Calculate Running Total** | *SUM* |

**Get Subtotal By Invoice Number** | *COUNTIFSUMIFIF* |

**Sum Values By Group ** | *SUMIFIF* |

**Subtotal By Colors** | *SUMIF* |

**Two-Way Summary Counting** | *COUNTIF* |

**Subtotal Invoice Amounts By Age ** | *SUMIF* |

**Sum All Number Cells Ignoring Errors ** | *SUMIFIFERRORAGGREGATE* |

**Sum Smallest Or Bottom N Values ** | *SUMPRODUCTSMALL* |

**Sum Smallest Or Bottom N Values Based On Criteria ** | *SUMSMALLIF* |

**Sum Values By Month (With Or Without Year)** | *SUMIFSSUMPRODUCTEOMONTHMONTH* |

**Sum Values By The Week Of A Given Date** | *SUMIFS* |

**Sum Values By Weeknum Or Weekday** | *WEEKNUMSUMPRODUCTWEEKDAY* |

**Sum Every N Rows Or Columns** | *SUMOFFSETROWCOLUMNS* |

**Sum Every Nth Row Or Column** | *SUMPRODUCTMODROWCOLUMN* |

**Sum If Begins With Or Ends With Specific Text Or Characters** | *SUMIF* |

**Sum If Cells Contain Specific Text In Another Column** | *SUMIFSUMPRODUCTSEARCHISNUMBER* |

**Sum If Between Two Values ** | *SUMIFS* |

**Sum Only Cells Containing Formulas** | *SUMPRODUCTISFORMULA* |

**Sum Values By Year** | *SUMPRODUCT SUMIFS DATE YEAR* |

**Sum If Cells Contain An Asterisk** | *SUMIF* |

**Sum If Cells Contain Both X And Y** | *SUMIFS* |

**Sum If Cells Contain Or Equal To Either X Or Y** | *SUMPRODUCT ISNUMBER SEARCH SUMIFS* |

**Sum If Date Is Between Two Dates** | *SUMIFS* |

**Sum If Cells Are Equal Or Not Equal To A Certain Value** | *SUMIF* |

**Sum If Greater Than Or Less Than A Specific Value** | *SUMIF* |

**Sum If Date Is Greater Than Or Less Than A Specific Date** | *SUMIF* |

**Sum If Equal To One Of Many Things ** | *SUMIFSUMPRODUCT * |

**Sum Values Based On Blank Or Not-Blank Criteria ** | *SUMIF* |

**Sumif With Multiple Criteria Based On OR And AND Logic** | *SUMIFSUMIFS* |

**Sum Multiple Columns If One Criterion Is Met** | *SUMPRODUCT* |

**Sum The Last N Columns** | *SUM INDEX COLUMNS* |

**Sum Top N Values Or Top N Values With Criteria** | *SUMPRODUCT LARGE* |

**Sum Values Based On Column Or Both Column And Row** | *SUMPRODUCT* |

**Sum Values In Last N Days Based On Criteria** | *SUMIFS TODAY* |

**Sum only visible cells or rows in a filtered list** | *SUBTOTAL* |

**Sum values in horizontal range** | *SUMIFS* |

**Use SUMIFS with multiple criteria based on OR logic** | *SUMSUMIFS* |

**Use SUMPRODUCT with IF function** | *SUMPRODUCT* |

**Financial** |

**Calculate interest payments per period or total** | *IPMTCUMIPMT* |

**Lookup** |

**Approximate match with INDEX and MATCH** | *INDEXMATCH* |

**Approximate match with VLOOKUP** | *VLOOKUP* |

**Case-sensitive lookup** | *INDEXMATCHVLOOKUPEXACTCHOOSE* |

**Case-sensitive lookup to return matching numbers** | *SUMPRODUCTMATCHEXACT* |

**Count missing values** | *SUMPRODUCTMATCHISNACOUNTIF* |

**Dynamic worksheet or workbook reference** | *INDIRECT* |

**Exact match with INDEX and MATCH** | *INDEXMATCH* |

**Exact match with VLOOKUP** | *VLOOKUP* |

**Find longest or shortest text string in a column or row** | *INDEXMATCHLENMAXMIN* |

**Find longest text string with criteria** | *INDEXMATCHLENMAX* |

**Find missing values** | *IFISNAMATCHVLOOKUPCOUNTIF* |

**Get cell address of lookup results** | *INDEXMATCHCELL* |

**Get first non-blank value in a column or row** | *INDEXMATCHISBLANK* |

**Get first numeric value in a column or row** | *INDEXMATCHISNUMBER* |

**Get first text value in a column** | *INDEXMATCHVLOOKUP* |

**Get first text value in a row** | *HLOOKUP* |

**Get information corresponding to maximum value** | *INDEXMATCHMAX* |

**Get information corresponding to minimum value** | *INDEXMATCHMIN* |

**Get last text value in a column** | *INDEXMATCH* |

**Get student or employee information with VLOOKUP** | *VLOOKUP* |

**Get value at given row and column** | *INDEXMATCHSMALL* |

**INDEX and MATCH across multiple columns** | *INDEXMATCHMMULTTRANSPOSECOLUMN* |

**INDEX and MATCH with multiple arrays** | *INDEXMATCHCHOOSE* |

**Left lookup with INDEX and MATCH** | *INDEXMATCH* |

**Left lookup with VLOOKUP** | *VLOOKUPCHOOSE* |

**Locate maximum value in a range** | *MATCHMAX* |

**Locate first error** | *MATCHISERROR* |

**Locate first match that does not begin with** | *MATCHLEFTIF* |

**Locate first match that does not contain** | *MATCHISNUMBERSEARCH* |

**Locate first partial match with wildcards** | *MATCH* |

**Lookup a value containing specific text with wildcards** | *INDEXMATCH* |

**Lookup closest match** | *INDEXMATCHABSMIN* |

**Lookup closest match value with multiple criteria** | *IFINDEXMATCH* |

**Lookup and retrieve entire column** | *INDEXMATCHSUMAVERAGEMAXLARGE* |

**Lookup and retrieve entire row** | *INDEXMATCHSUMAVERAGEMIN* |

**Lookup next largest match with INDEX and MATCH** | *INDEXMATCH* |

**Lookup the first partial match number** | *MATCHTEXTINDEX* |

**Lookup values in descending order** | *INDEXMATCH* |

**Lookup values from another worksheet or workbook** | *VLOOKUP* |

**Merge tables with INDEX and MATCH** | *INDEXMATCH* |

**Multiple-criteria lookup with INDEX and MATCH** | *INDEXMATCH* |

**Partial match with VLOOKUP** | *VLOOKUP* |

**Retrieve first list value from a cell** | *INDEXMATCHSEARCHISNUMBER* |

**Retrieve first matching value in cell against a list** | *INDEXMATCHSEARCHAGGREGATE* |

**Retrieve information associated with lowest n values** | *VLOOKUP* |

**Retrieve nth match with INDEX** | *INDEXROWSMALLIF* |

**Retrieve nth match with VLOOKUP** | *VLOOKUP* |

**Shipping cost calculator** | *VLOOKUP* |

**Two-way approximate match with multiple criteria** | *INDEXMATCHIF* |

**Two-way lookup with INDEX and MATCH** | *INDEXMATCH* |

**Vlookup with dymanic sheet name** | *VLOOKUPINDIRECT* |

**Math** |

**Convert binary value to decimal or octal or hex value** | *BIN2DECDECIMALBIN2OCTBIN2HEX* |

**Convert hexadecimal value to decimal or binary or octal value** | *HEX2DECDECIMALHEX2OCTHEX2BIN* |

**Convert octal value to decimal or binary or hexadecimal value** | *OCT2DECDECIMALOCT2HEXOCT2BIN* |

**Convert decimal value to binary or octal or hexadecimal value** | *DEC2DECDEC2OCTDEC2HEX* |

**Convert decimal number to IP address** | *MID* |

**Convert decimal to whole number in Excel** | *ROUND ROUNDDOWN ROUNDUP* |

**Date and Time** |

**Add business days to date ** | *WORKDAYWORKDAT.INTL* |

**Add hours to time ** | *TIME MOD* |

**Add minutes to time ** | *TIME MOD* |

**Add hours minutes seconds to time ** | *TIME* |

**Add months to date ** | |

**Add years to date ** | *DATEYEARMONTHDAY* |

**Assign points based on late time** | *IFVALUE* |

**Add or subtract days to date ** | |

**Calculate days hours minutes seconds between two dates** | *TEXT* |

**Calculate days remaining from today** | *MAXTODAY* |

**Calculate days remaining between dates** | |

**Calculate days remaining in month** | *EOMONTH* |

**Calculate days remaining in year** | |

**Calculate difference between two dates** | *DATEDIF* |

**Calculate difference between two times** | *IF* |

**Calculate expiry date** | *EOMONTHEDATE* |

**Calculate hours minutes seconds between to times** | *HOUR MINUTE SECOND* |

**Calculate network time** | *MOD* |

**Calculate retirement date** | EDATE |

**Calculate overlapping days** | *MAXMIN* |

**Calculate overtime pay** | |

**Calculate years months days between two dates** | *DATEDIF* |

**Check if dates is workday** | *WORKDAY WORKDAY.INTL* |

**Check if date is last n day** | *TODAY* *AND* |

**Check if date is last n month from today** | *TODAY* *AND EOMONTH* |

**Check if two dates are in same year month** | *MONTH YEAR* |

**Combine date and time** | *TEXT* *CONCATENATE* |

**Convert date to Julian** | *TEXT* *YEAR* *DATE* |

**Convert date to month year day** | *TEXT* |

**Convert date to text** | *TEXT* |

**Convert datetime string to datetime** | *LEFT* *MID* |

**Convert decimal hours to time** | |

**Convert decimal minutes to time** | |

**Convert month name to number** | *DATEVALUE* *MONTH* |

**Convert number to date** | *TEXT LEFT MID RIGHT DATE* |

**Convert time to another time zone** | *MOD* |

**Convert time to decimal hours** | |

**Convert time to decimal minutes** | |

**Convert time to decimal seconds** | |

**Convert time to money** | |

**Convert time to Unix** | *DATE* |

**Convert timestamp to time** | *MID* *TIME* |

**Convert text to time** | *DATEVALUE VALUE* |

**Count days of month** | *EOMONTH DAY* |

**Count days until expiration date** | *TODAY* |

**Count day of week between two dates** | *INDIRECR ROW WEEKDAY SUMPRODUCT* |

**Count day of week in a date range** | *WEEKDAY SUMPRODUCT* |

**Count days from Today** | *TODAY* *IF* *ISBLANK* *ABS* |

**Count days between two dates** | *DATEDIF* |

**Count dyas left in current month year** | *EOMONTH YEAR DATE* |

**Count holidays between two dates** | *SUMPRODUCT* |

**Count months between two dates** | *DATEDIF YEARFRAC* |

**Count number of calls in a time range** | *COUNTIFS* |

**Count times in a range** | *COUNTIFS* |

**Count workday only** | *NETWORKDAYS NETWORKDAYS.INTL* |

**Create date range from two dates** | *TEXT* |

**Create dynamic date list** | *ROWS* |

**Create weekly date range** | ROWS TEXT |

**Custom format weekday name** | *WEEKDAY CHOOSE* |

**Display current date or time** | *TODAY NOW* |

**Extract time only from datetime in Excel** | *TIMEMOD* |

**Extract date only from datetime in Excel** | *INTTRUNC DATE * |

**Find earlest or latest date of each group** | *IF MAX MIN* |

**Find last weekday of month** | *EOMONTH WEEKDAY* |

**Find next date in schedule list** | |

**Get day name from given date** | *TEXT WEEKDAY CHOOSE* |

**Get date from day month year** | *DATE* |

**Get first or last workday in month** | *YEAR ** * *MONTH DATE WORKDAY* |

**Get fiscal month from date** | *MONTH CHOOSE* |

**Get fiscal quarter from date** | *MONTH CHOOSE* |

**Get fiscal year from date** | *MONTH YEAR* |

**Get first or last day of month by given date** | *DAY EOMONTH* |

**Get first day of month by month text name** | * IF* |

**Get first or last day of previous month** | *EOMONTH* |

**Get midpoint of two dates** | *SUM WORKDAY* |

**Get Monday of week** | *WEEKDAY* |

**Get month from date** | *MONTH* |

**Get most recently day of week** | *MOD* |

**Get next specific weekday** | *WEEKDAY* |

**Get nth day of week in month by given date** | *WEEKDAY DAY* |

**Get nth day of year by given date** | *YEAR DATE* |

**Get number of workday between two dates** | *NETWORKDAYS NETWORKDAYS.INTL* |

**Get percentage of year complete or remained** | *YEAR DATE YEARFRAC* |

**Get quarter from date** | *MONTH YEAR* |

**Get same date last month or next month** | *EDATE* |

**Get same date last year or next year** | *EDATE* |

**Get week number from date in Excel** | *WEEKNUM* |

**Get work hours between two dates in Excel** | *NETWORKDAYS NETWORKDAYS.INTL* |

**Get or calculate age from birth date in Excel** | *YEARFRAC DATEDIF* |

**List holidays between two dates** | *IF TEXTJOIN* |

**Text** |

**Abbreviate Words or Names** | *TEXTJOIN ISNUMBER ROW INDIRECT LEN MATCH MID TRIM LEFT SUBSTITUTE FIND UPPER* |

**Add area code or country code to phone number** | *CONCATENATE * |

**Add character before each word** | *SUBSTITUTE * |

**Add comma after first word** | *REPLACE FIND* |

**Add comma between names** | *FINDREPLACE TRIM SUBSTITUTE * |

**Add dashes to phone number** | *REPLACE * |

**Add dashes to SSN in a cell** | *LEFT MID RIGHT SUBSTITUTE* |

**Add leading zeros to fix text length** | *TEXT* |

**Add text in middle** | *LEFT MID REPLACE* |

**Add space after comma** | *TRIM SUBSTITUTE* |

**Add space between number and text** | *TRIMREPLACE MIN FIND MAX IFERROR ROW INDIRECT LEN* |

**Capitalize first letter of text string or each word** | *UPPERLEN FIND LOWER REPLACE LEFT MID* |

**Check if a cell contains a specific text** | *ISNUMBER SEARCH FIND* |

**Check if cell contains all of many things** | *SUMPRODUCT ISNUMBER SEARCH COUNTA* |

**Check if cell contains one of many things** | *SUMPRODUCT ISNUMBER SEARCH* |

**Check if a cell contains one of several values but exclude other values** | *SUMPRODUCT ISNUMBER SEARCH* |

**Check if cell contains some texts but not contains others** | *COUNT* *SEARCH* *AND* |

**Convert letter to number** | *COLUMN* *INDIRECT* |

**Check if cell contains number** | *COUNT FIND* |

**Combine cells with line break** | *CONCATENATE* |

**Combine date and time into one cell in Excel** | *TEXT* |

**Combine text and date into same cell in Excel** | *TEXT CONCATENATE * |

**Count comma separated values in a cell** | *LEN SUBSTITUTE TRIM* |

**Count specific character in cell** | *LEN SUBSTITUTE* |

**Count specific character in a range of cells** | *SUMPRODUCT LEN SUBSTITUTE* |

**Count specific words in cell** | *LEN SUBSTITUTE* |

**Count specific words in a range of cells** | *SUMPRODUCT LEN SUBSTITUTE* |

**Count number of characters in a cell** | *LEN* |

**Count number of characters in a range of cells** | *SUMPRODUCT LEN* |

**Count number of words in a cell** | *LEN TRIM SUBSTITUTE* |

**Count number of words in a range of cells** | *SUMPRODUCT LEN TRIM SUBSTITUTE* |

**Use double quotes in formulas** | *CHAR* |

**Check if cell equals any value in list** | *SUMPRODUCT* |

**Clean and reformat telephone numbers** | *SUBSTITUTE* |

**Combine cells with commas** | *TRIM SUBSTITUTE CONCATENATE* |

**Combine initial and last name** | *LEFT CONCATENATE* |

**Compare two or more text strings** | *EXACT IF COUNTIF* |

**Concatenate cells but ignore blanks** | *TEXTJOIN * |

**Convert numbers to text in Excel** | *TEXT FIXED* |

**Convert text to number in Excel** | *VALUE RIGHT LEFT MID* |

**Count keywords cell contains based on a list** | *SUMPRODUCT ISNUMBER SEARCH* |

**Count lines which are separated by line breaks in a cell or a range** | *LEN SUBSTITUTE* |

**Show specific text based on value in Excel** | *REPT IF* |

**Extract all words but first or last from a cell** | *RIGHT LEN FIND LEFT SUBSTITUTE* |

**Extract capital letters only** | *SUBSTITUTE* |

**Extract extension from filename** | *RIGHT LEN FIND SEARCH REPLACE* |

**Extract filename from a path in Excel** | *MID FIND SUBSTITUTE LEN IFERROR* |

**Extract first line of cell** | *SEARCH LEFT * |

**Extract first and last name from email** | *FIND LEFT LEN RIGHT* |

**Extract folder name from path** | *FIND SUBSTITUTE LEN RIGHT* |

**Extract from right until a character** | *SEARCH RIGHT SUBSTITUTE LEN IFERROR* |

**Extract initials from names** | *MID IF FIND LEFT * |

**Extract multiple lines from a cell** | *TRIM MID REPT LEN SUBSTITUTE* |

**Extract last line of text from a multi-line cell** | *SUBSTITUTE REPT RIGHT TRIM* |

**Extract nth word from text string in Excel** | *SUBSTITUTE REPT MID TRIM LEN* |

**Extract path from full path** | *FIND SUBSTITUTE LEN LEFT* |

**Extract substring from text string in Excel** | *MID LEFT RIGHT SEARCH* |

**Extract the last two words from a cell** | *MID FIND SUBSTITUTE LEN* |

**Extract text between parentheses from text string** | *MID SEARCH* |

**Extract word beginning with a specific character in Excel** | *MID TRIM LEFT FIND REPT LEN SUBSTITUTE* |

**Extract word which containing specific text in Excel** | *MID TRIM FIND REPT MAX SUBSTITUTE* |

**Extract first initial and last name from full name** | *LEFT RIGHT FIND LEN* |

**Extract first middle and last names from full name in Excel** | *LEFT RIGHT FIND LEN MID SEARCH SUBSTITUTE* |

**Extract text before or after second space or comma** | *LEFT MID FIND SUBSTITUTE TRIM* |

**Extract text after the last instance of a specific character** | *RIGHT SEARCH LEN SUBSTITUTE TRIM REPT* |

**Extract text between first and second comma from text strings** | *MID SEARCH FIND SUBSTITUTE * |

**Find and replace multiple values in Excel** | *SUBSTITUTE INDEX* |

**Find nth occurrence of character in a cell** | *SUBSTITUTE FIND* |

**Find most frequenst text in a range** | *MODE INDEX MATCH* |

**Find most frequenst text with criteria** | *MODE INDEX IF MATCH* |

**Find position of nth occurrence** | *FIND SUBSTITUTE* |

**Flip or reverse first and last names in Excel list** | *MID SEARCH LEN* |

**Get or extract the first word from text string in Excel** | *FIND LEFT* |

**Get or extract the last word from text string in Excel** | *TRIM RIGHT REPT* |

**If cell contains text then display in Excel** | *IF ISNUMBER SEARCH* |

**Make text same length** | *REPT LEN* |

**Make first letter lowercase** | *LEFT LOWER REPLACE* |

**Move or combine multiple cell contents into one cell** | *CONCATENATE TRANSPOSE TEXTJOIN * |

**Normalize text** | *TRIM SUBSTITUTE LOWER* |

**Remove extension from filename** | *FIND LEFT* |

**Remove first n characters** | *LEN RIGHT* |

**Remove first or last word from a string** | *RIGHT LEN FIND LEFT TRIM SUBSTITUTE* |

**Remove from right of text** | *LEN LEFT* |

**Excel remove last or trailing comma in a cell** | *IF RIGHT LEFT LEN* |

**Remove leading and tailing space** | *CLEAN TRIM SUBSTITUTE* |

**Remove line breaks from cells in Excel** | *CLEAN TRIM SUBSTITUTE* |

**Remove middle initial from full name in Excel** | *LEFT RIGHT FIND TRIM SUBSTITUTE REPT* |

**Remove prefix or suffix from string** | *RIGHT LEN LEFT* |

**Remove text from cell by matching the content ** | *SUBSTITUTE* |

**Remove text from a cell based on specific position** | *REPLACE SUBSTITUTE* |

**Remove text based on variable position in Excel** | *REPLACE FIND* |

**Remove unwanted characters from cell in Excel** | *SUBSTITUTE* |

**Remove text before or after first or last specific character from text strings** | *RIGHT LEFT FIND SEARCH LEN SUBSTITUTE* |

**Remove text after or before the second or nth space from text strings** | *RIGHT LEFT FINDLEN SUBSTITUTE* |

**Remove text within parentheses or brackets from text strings** | * FIND MID LEN SUBSTITUTE* |

**Replace a specific character in a cell with another ** | *SUBSTITUTE* |

**Reverse the text string in a cell in Excel** | *TEXTJOIN MID* |

**Split dimensions into individual length, height and width** | *LEFT MID RIGHT FIND LEN SUBSTITUTE* |

**Split dimensions into two parts in Excel** | *LEFT RIGHT FIND LEN SUBSTITUTE* |

**Separate numbers from units of measurement** | *MAX ISNUMBER VALUE MID LEFT TRIM RIGHT* |

**Separate octets of IP address in Excel** | *LEFT MID LEN FIND* |

**Separate Email addresses to usernames and domains** | *LEFT RIGHT LEN FIND* |

**Split dollars and cents** | *FIND RIGHT LEN* |

**Split a cell by first space in Excel** | *LEFT FIND RIGHT LEN* |

**Split number into individual digits** | *MID COLUMN* |

**Split sentence into words** | *SEARCH MID ROW COLUMN IF * |

**Split text and numbers** | *MID FIND LEFT RIGHT LEN* |

**Split text string at specific character in a cell in Excel** | *MID FIND LEFT RIGHT LEN* |

**Split text with delimiter in a cell in Excel** | *MID TRIM SUBSTITUTE LEN* |

**Strip or remove non-numeric characters from text strings** | *TEXTJOIN IFERROR MID ROW INDIRECT* |

**Strip or remove numeric characters from text strings** | *TEXTJOIN IF ISERR MID ROW INDIRECT LEN* |

**Strip or remove html tags from text strings** | *MID LEN* |

**Trim text to n words** | *SUBSTITUTE FIND LEFT* |