CONCATENATE Function

How to Concatenate Number and String in Google Sheets

Today we will look at a couple of ways to concatenate number and string in Google Sheets. We will also see some advanced examples based on combining ...

How to Concatenate With Separator in Google Sheets (3 Ways)

Separators, or more technically known as delimiters, are a crucial part of making concatenated values in spreadsheets more presentable. Today, we ...

How to Concatenate Strings in Google Sheets (2 Easy Ways)

Concatenating values is one of the more fundamental tasks performed in a spreadsheet. Today, we will be specifically looking into how to concatenate ...

INDEX-MATCH with Multiple Criteria in Google Sheets (Easy Guide)

We are already aware of how powerful the INDEX-MATCH combination is when extracting data in Google Sheets. If not, please visit our Using INDEX MATCH ...

How to Merge Cells In Google Sheets Without Losing Data

Sometimes, the traditional ways to merge cells in google sheets may not cut it, thanks to the wiping of data that happens with the built-in function. ...

How to Merge Columns in Google Sheets

Knowing how to merge columns in Google Sheets is a fairly easy affair. But things can get complicated when a lot of data and specific criteria are ...

How to Merge Rows in Google Sheets (3 Ways)

Merging cells in a spreadsheet is one of the more fundamental skills to have. But things might get complex when certain patterns of merges are ...

OfficeWheel
Logo