Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Cuts string of list of items Formulas - combined functions
  • Week number to Sunday date – Weeknum reverse DATE
  • Cells with additional spaces AND
  • MID + SEARCH to convert cell to rows MID
  • DayName Date and Time
  • 6174 Kaprekar’s constant Basic Math
  • State Abbr with Index+Match+Validation Data Validation
  • Min Max vehicle Formulas - combined functions

Category: Texts and Strings

Middle name + 1st name

Posted on February 3, 2024 By ANmar
Middle name + 1st name

Get the initial (middle name) from a triple name in a cell.
C4 The cell contains the triple name separated with spaces.
=LEFT(C4,1) & "." & MID(C4, SEARCH(" ", C4, 1) + 1, 1) & "." & MID(C4, SEARCH(" ", C4, SEARCH(" ", C4, 1) + 1) + 1, 1) & "."

Read More “Middle name + 1st name” »

Basic Math, Formulas - combined functions, LEFT, MID, SEARCH, Standard functions, Texts and Strings

Jan8 date format

Posted on April 24, 2023 By ANmar
Jan8 date format

Format a date in shortest format possible indicating how many days have passed (Past date)

If date1-date2 < 8 Sat, Fri, …
If date1-date2 < 350 Dec24, Jan4, Aug14
Else 2020Feb4

Read More “Jan8 date format” »

AND, Date and Time, Formulas - combined functions, IF, Logical, Standard functions, TEXT, Texts and Strings, TODAY

6174 Kaprekar’s constant

Posted on September 2, 2022 By ANmar
6174 Kaprekar’s constant

This is the spreadsheet to prove this constant. When all roads lead to Kaprekar

Just enter any 4 digits number in D3 and watch roads walk you 6174

Read More “6174 Kaprekar’s constant” »

Basic Math, Formulas - combined functions, Standard functions, TEXT, Texts and Strings, VALUE

Cuts string of list of items

Posted on August 17, 2022 By ANmar
Cuts string of list of items

An old lesson to one of my early classes to show how can we cut a string having list of items into its parts. (At least 1st three parts) using formulas only.

Read More “Cuts string of list of items” »

Formulas - combined functions, LEFT, MID, SEARCH, Standard functions, Texts and Strings

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

VALUE() of LEFT()

Posted on July 7, 2022 By ANmar
VALUE() of LEFT()

I have been in a lot of situation needing to convert a number came out from a string into actual numbers. Sometimes N() worked, sometimes not, others VALUE() worked, but I did not see a function-does-all solution.

Read More “VALUE() of LEFT()” »

Formulas - combined functions, IF, IFERROR, Information, LEFT, Logical, N, Standard functions, Texts and Strings, VALUE

DayName

Posted on January 25, 2019 By ANmar
DayName

Simplest way to get name of day as cell output from a date.

Because you can custom format a cell with date to show only that day name

This is not that.

Read More “DayName” »

Date and Time, Standard functions, TEXT, Texts and Strings

Fixed length ID

Posted on January 22, 2019 By ANmar
Fixed length ID

I needed few months back to make a fixed-length ID iut if none-fixed-length numbers.

SO I used the function REPT with RIGHT to force all numbers to be converted into fixed-length ID (mainly having leading zeros)

And here is the formula

Read More “Fixed length ID” »

Formulas - combined functions, REPT, RIGHT, Texts and Strings

Worksheet name, dynamically using formula

Posted on April 3, 2018 By ANmar
Worksheet name, dynamically using formula

Get the name of the active worksheet in active workbook, using formulas only

This function needs to have workbook saved

Then, you just paste below formula into any cell …

Read More “Worksheet name, dynamically using formula” »

CELL, MID, SEARCH

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

Posts pagination

1 2 3 Next

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
  • Edit directly in cell Excel User tips
  • Convert cell into textbox Excel User tips
  • Shades of gray Graphics
  • Sum of divide – Array formula Array formula
  • Stale values (Scratched functions) Excel User tips
  • Always get 1st name (or last) Formulas - combined functions
  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Links between two workbooks – dynamically using functions INDIRECT

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme