Not a subscriber? Subscribe here.
Tech Productivity

Issue #197  (Microbreaks to Prevent Burnout) 11/21/22

Bytes: Your Favourite JavaScript Newsletter
I subscribe to a lot of newsletters, but this is definitely one I look forward to. Entertaining with lots of cool and useful coding tidbits and tools.

Subscribe to Bytes
I'm pretty hopeless when it comes to Excel and Google Sheets (or similar spreadsheet apps), so I was excited to learn a few useful functions that are similar to functions we have available in programming languages: These are specifically for Google Sheets, but I'm sure there are similar equivalents for other spreadsheet apps.

The SPLIT() function accepts two arguments: (1) The text or location of the text you want to split; (2) the delimiter that defines where to split the text. So you'll have something like =SPLIT(A1," ") in your cell formula. In that case, I'm splitting my text using the space character. This might be useful if I have a list of names in a single column. If I want to "split" the names into first and last (or first, middle, last), this would work as it distributes the newly split values into multiple cells.
Splitting Values in Google Sheets

The CONCAT() function does essentially the opposite, concatenating two values. If I want to concatenate more than two values, I can use CONCATENATE(). So in this case, I might have a list of first and last names, and possibly a middle name. I can then do something like =CONCAT(B1,C1) to merge the names together into a single cell.

If I want to add a space in between the merged words, I would use something like =CONCATENATE(B1, " ", C1).The longer function  allows more than two arguments, so I can add the optional space.

Concatenating Values in Google Sheets

Easy stuff for some of you spreadsheet experts? Probably! But useful functions to keep in mind for those of us who don't often work in spreadsheet apps.

Now on to this week's hand-picked productivity links!


Tools & Apps

Paste — A clipboard app that permanently stores everything you copy on your Mac, iPhone, and iPad, with intelligent search capabilities.

aQRoss — Clever name. An online app that lets you share files across devices using QR codes. Also includes a 'group' files option.

Smartcue — App + Chrome extension to create more effective and personalized product demos in minutes, not hours, with as little friction to your current workflows.

Tability — A platform that gives your team a central place to track and discuss progress on goals.

Bytes: Your Favourite JavaScript Newsletter — I subscribe to a lot of newsletters, but this is definitely one I look forward to. Entertaining with lots of cool and useful coding tidbits and tools.    sponsor  

Add to Notion — A Notion extension application, for Mac or Windows, to easily add your day-to-day findings to your Notion spaces from any app or browser.

Day One — Mac or iOS journaling app that includes automatic backups, data encryption, various export options, and more.


Have a suggestion for a productivity-related tool, article, or other resource? Send me a direct message via X (@LouisLazaris) and I’ll consider including it in a future issue.

Stay productive!


Copyright © Lazarpress, All rights reserved.

Not subscribed? Visit to join today.