Category: Texts and Strings

Middle name + 1st name

Jan8 date format

6174 Kaprekar’s constant

Cuts string of list of items

Cells with additional spaces

Always get 1st name (or last)

VALUE() of LEFT()

DayName

Fixed length ID

Worksheet name, dynamically using formula

Text-to-Columns, dynamically using formulas