Google Sheets
Find and replace special characters in Google Sheets
Getting tired of all those smart quotes, accented letters, and other unwanted special characters in Google Sheets? We have a few ideas on how to replace them effortlessly. Continue reading
Video: remove the same characters and substrings from multiple Google Sheets cells
Today's video is all about getting rid of unwanted text from several Google Sheets cells at once. You'll see how our Remove Text add-on removes specific characters and various substrings from different positions in cells. Continue reading
Extract data from Google Sheets cells: text, numbers, URLs, hyperlinks, email addresses, dates, and time
This next bit of our operations with text in spreadsheets is devoted to extraction. Find out ways to extract various data – text, characters, numbers, URLs, email addresses, date & time, etc. – from various positions in multiple Google Sheets cells at once. Continue reading
Video: how to add text to multiple Google Sheets cells
We have plenty of useful add-ons to manage text in spreadsheets. Add Text is one of them. Watch today's video to learn how to insert the same text to multiple Google Sheets cells: at the beginning & at the end of cells, after the Nth character, before/after a certain text string. Continue reading
Video: how to split cells with text to multiple columns in Google Sheets
Yet another splitting instrument for your Google spreadsheet toolset: Split Text add-on. It splits cells in Google Sheets by multiple delimiters at once, by text strings, by the desired position, and even by capital letters. Come see for yourself ;) Continue reading
Google Sheets: remove the same text or certain characters from multiple cells at once
Learn formulas and formula-free ways for Google Sheets to trim whitespaces, remove special symbols (even the first/last N characters) and the same text strings before/after certain chars from multiple cells at once. Continue reading
Add text to Google Sheets cells at a certain position: at the beginning/end, before/after characters
This tutorial will teach you how to add text in Google Sheets at the same position of all cells at once: at the beginning, at the end, after the N-th character, before or after particular characters. Continue reading
Video: how to split cells with names in Google Sheets
Come take a look at our Split Names add-on for Google Sheets. It's much more powerful than the standard Split text to columns tool for it separates first, middle and last names, and recognizes more than 80 titles and 40 post-nominals in any name combinations. Continue reading
Video: how to change case in Google Sheets
When it comes to changing cases in Google Sheets, formulas are hardly the best option. Come take a look at a small utility that changes cases in your entire selection on the fly. Continue reading
How to change case in Google Sheets: UPPER, lower, Capitalize Each Word, Sentence case, tOGGLE
Changing text case in Google Sheets may seem an intricate task as there is no such option in the standard menu. Even so, the task is very much resolvable. In this blog post, I share different ways to capitalize your words or turn them into lowercase, uppercase, and sentence case. Continue reading
Video: how to enable formulas built by the Combine Sheets add-on
If you're about to pull data from multiple Google sheets into one using our Combine Sheets add-on, you will most likely try to get the result as a formula to keep it in-sync with the original tables. This video features 2 important steps you have to take before that formula starts working for you. Continue reading
Video: how to pull data from other Google sheets into one table
Today's video features the easiest way to combine numerous Google sheets into one. Combine Sheets add-on brings data from different documents and common columns together, keeps your formatting, and automatically supplies the resulting table with the up-to-date info from the source sheets. Continue reading
Video series: 3 quick ways to merge multiple Google sheets
There's a perfect solution we all seek to combine data from multiple sheets: open the table, make 3 mouse clicks at most, and get the exact desired result without any extra tools or adjustments. But until there's an AI like in movies, we have to use other software at hands. Today I will show you 3 powerful add-ons that will help you combine several Google sheets into one. Continue reading
Count words and characters in Google Sheets: LEN function
Though word and character count in Google Sheets are used in rare cases, it is still the functionality that some of us expect to see right in the menu. But unlike Google Docs, for Google Sheets, it is the LEN function that does that. Continue reading
Calculate days, months and years between two dates in Google Sheets: DATEDIF formulas
Today's blog post is all about figuring out the difference between two dates in Google Sheets. Come find lots of DATEDIF formulas to count days, months and years, and learn how NETWORKDAYS is used to count only workdays even if your holidays are based on a custom schedule. Continue reading
Video: how to consolidate data from multiple Google sheets by common columns
This video shows how to merge several Google sheets into one and calculate all numbers from the same columns at the same time. With a handy add-on that we offer, you won't have to open each file and copy-paste data manually anymore. Continue reading
Video: how to combine duplicate rows in Google Sheets
This video shows how you can merge and consolidate rows with duplicate data using the Combine Duplicate Rows add-on. Three simple yet advantageous steps will let you select data and pick columns to merge or concatenate. Continue reading
Video: how to vlookup multiple values in Google Sheets
This video tutorial shows the easiest way to vlookup by multiple criteria in Google Sheets. The add-on finds all matches and pulls data from another sheet as values or as ready-made Google Sheets QUERY formula. Continue reading
INDEX MATCH in Google Sheets – flexible Vlookup for your spreadsheets
When you need to find data in your sheet that corresponds to a certain key record, it is usually Google Sheets VLOOKUP you turn to. But there you go: VLOOKUP slaps you with limitations almost immediately. That's why you'd better increase the resources for the task by learning INDEX MATCH. Continue reading
Google Sheets QUERY function: a spreadsheet cure-all you have yet to discover
If you've been following this blog for a while, you may remember QUERY. I mentioned it as a possible solution for a couple of cases. But those are far from enough to uncover its full potential. Today, it's high time we get to know this spreadsheets superhero properly. And guess what – one equally noteworthy tool will also be there :) Continue reading
