How to Use a Formula Across a Range – ARRAYFORMULA
I use this all the time instead of having to type out every single cell name.
How to Paste Multiple Entries into the Same Cell – TEXTJOIN
I used this for a tag generator option. Advantage over JOIN is if you have a blank cell.
How to Paste Multiple Entries into the Same Cell – JOIN
I needed to create a list of zip codes separated by a semicolon. I used this to take a list of zipcodes in separate cells and turn them into a string in one cell.
How to Split Numbers From a String of Text – SPLIT
I needed to split a number from a text string so I could do an operation on it. I needed to take “435.6 pounds” and split off the ‘pounds’. Here’s how I did it.
A1: 435.6 pounds
B1: =SPLIT( LOWER(A1) ; “abcdefhijklmnopqrstuvwxyz ” )
LOWER just takes any capital letters and makes them lowercase so it fits the delimiter. It’s not necessary in this particular function but may be useful to you.
Add Quotes to Cells Automatically
I had an additional constraint for the tag generator. I needed to have quotes around the entry so that Shopify could plug it into it’s database. So I found this solution for Excel but that also works for Sheets.
- Highlight the cell range.
- Go to Format ->Number-> More Formats -> Custom Number Format
- Paste in: ”@”
- Click ‘Apply’
- After you do this once, it should appear as an option
How to Check / Uncheck Multiple Boxes in Google Sheets at the Same Time
1)Select the range of checkboxes by either clicking and dragging the corner of a cell box or by clicking the first cell, holding the shift key, and selecting the last cell.
2)Use the space bar to select / unselect boxes.