Many of us (if not all), use Google Sheets as a database, and we use it to store data for our projects. But sometimes you need more than just simple data storage. You want to get the value from one cell or range, based on another cell or range. This is where the Lookup function comes into play.
In this tutorial, I will show you how to do that using Google Sheet’s built-in function LOOKUP.

OK, this is a pretty common task! Having a “name” and a “surname” column, and wanting both merged into a single “full name” column. And even if we’re making this specific example, you can use this guide to merge the content of two or more cells regardless of their content being names or something else. I think every google sheets user will need this sooner or later. I needed it so many times!

I found myself in the need of merging two adjacent cells in google sheets without losing the data contained in them. I searched online and found everyone suggesting to download an addon. But then you discover the addon is not completely free, and I don’t want to give access to my data to an addon only to make a simple task. So I found an alternative method to merge two cells joining the content.

Google Sheets is a great tool to save, organize and share data. It can be used for creating spreadsheets or documents that include tables, charts, formulas, etc. The most important thing about this great tool is the ability to easily add text formatting such as bolding, italicizing, underlining, strikethrough. In the following paragraphs, we will

A complete guide on how to add a new line in a cell in Google Sheets using both keyboard shortcuts and functions to insert a line break in a formula.