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...
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...
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...
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...
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...
Multiple lines in cell using functions
You must already know that when you press Enter after you modify a cell, the cell content will be saved and you jump down to...
Extract current (Active) workbook name
I need that more often than I thought It is basically extract the full workbook name that we are in, with no folders, and with...