What is this Ampersand Doing in Google Sheets

In this video, I explain the purpose of the ampersand in Google Sheets and how it is commonly used for concatenation. I also explore its usage with text, numbers, and dates, highlighting its role in combining data and creating email addresses.
Additionally, I demonstrate how the ampersand can replace the need for a VLOOKUP chart when working with months.

00:00 Introduction
00:27 Normal Use of Ampersand
00:48 Interesting Use of Ampersand
01:20 Using Ampersand with Dates
03:03 Understanding the Ampersand in Month Calculation
08:26 Using Ampersand as an Alternative to VLOOKUP

[MISComputerNET]

Excellent tip, thanks for sharing! You have just got another subscriber

[DoranteVen]

Great tip! what about years other than the current one?