How To Format Text Like “1st Jan 22” To A Date In Google Sheets
How do you format a cell that contains text like 1st Jan 2022 into a cell that Google Sheets can recognize as a date cell? There are certain types of …
SPLIT
How To Capitalize First Letter Of Every Word In Python (One-Liner)
How do you capitalize the first letter of each word in a string using Python? To capitalize the first letter of every word in Python using one line of code …
How To Separate Characters Into Cells In Excel
If a cell contains words it can be easy to split these into individual cells using the Text to columns feature in Excel. Simply select the cells you want to …
Reverse Last Name & First Name With Comma Using One Formula: Google Sheets
Recently I had a column of names in a spreadsheet with the following structure: Last Name, First Name and they needed to change to the structure: First Name Last Name. …
Merge Two Columns Using QUERY: Google Sheets (Step By Step Example)
How do you merge multiple columns into one column in Google Sheets using the QUERY function? In this 4 simple step-by-step process we share the formula, and teach you along the way on how component within the function works by providing commentary and photos at each change.
Google Sheets QUERY: Merge Multiple Columns & Expand Into New Structure (Example)
Merge multi-columned data to one column before expanding it out into a different columned layout using the QUERY and ARRAYFORMULA functions in Google Sheets.
