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,...
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...
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...
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...
Extract Address into table
Convert US addresses from cells (one column with 1 line for Name, 1 line for address, one line for City, State and Zip code) into...
CamelCase to Camel Case
Here is a good practice for combining functions to get a full smartsheet It basically add a space before any capital letter in a text,...