Category: Texts and Strings

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...

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...