Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Tally chart in functions Formulas - combined functions
  • Highlight dates dynamically AND
  • Middle name + 1st name Basic Math
  • Blank (isempty) VS “” (null string) Excel User tips
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • Week number to Sunday date – Weeknum reverse DATE
  • Get monthly total from table with dates DATE
  • Search across sheets in function ADDRESS

Category: Len

Cells with additional spaces

Posted on August 4, 2022 By ANmar
Cells with additional spaces

Detect which cells has additional spaces added by mistake by user.

=IF(AND(Left(F2, 2) = "No", LEN(F2) >2, "Space at end", "")

Read More “Cells with additional spaces” »

AND, IF, LEFT, Len, Logical, Standard functions, Texts and Strings

Always get 1st name (or last)

Posted on July 23, 2022 By ANmar
Always get 1st name (or last)

Formula to get first name from 2 formats either (Lastname, First) or (Firstname Last) formats.

Read More “Always get 1st name (or last)” »

Formulas - combined functions, IF, ISERROR, LEFT, Len, Logical, RIGHT, SEARCH, Standard functions, Texts and Strings, TRIM

Text-to-Columns, dynamically using formulas

Posted on April 3, 2018 By ANmar
Text-to-Columns, dynamically using formulas

I often use the technique of concatenating columns into 1 cell with separators.

Something like the CSV, 1 line that has all values for a single row (all columns for that row) into 1 text block.

And then, because of that, I need to extract that back, into table

Read More “Text-to-Columns, dynamically using formulas” »

IFERROR, Len, MID, SEARCH

Count how many times letter found

Posted on March 3, 2017 By ANmar
Count how many times letter found

Found this in an old file while doing some digital cleaning This will show you how you can easily count how many times a letter (or any string) into a cell. So the main formula doing that is … =LEN(I12)-LEN(SUBSTITUTE(I12,”o”,””)) Of course, this assumes you are looking to find how many the letter “O” is…

Read More “Count how many times letter found” »

Formulas - combined functions, Len, Standard functions, SUBSTITUTE, Texts and Strings

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (82)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (5)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Filter. Google Sheets function Google Sheets
  • Excel Dynamic Drop-Downs that grow with you COUNTA
  • GoLast to jump to last cell in a column CELL
  • Sorting with functions only CHOOSE
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • Get 3rd Wednesday of month Basic Math
  • Spreadsheet Compare application Excel User tips
  • Progress bar in pure functions CHAR

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme