Work faster with Google Sheets and Excel

Looking for custom formulas for your daily work — copy and paste, and you are good to go

Excel and Google Sheets share about 90% of their functionality so learning/using one is a personal preference. I'll be using Google Sheets, which is free and all you need a Gmail account to start. Most of the formulas will work on Microsoft Excel and suitable if you have exposure to Excel or Sheets to some extend.

If you are an absolute beginner in Microsoft Excel or Google Sheet, I would recommend checking my personal favourite Mike Girvin channels on YouTube name ExcelIsFun. He absolutely saved my ass when I started my career as a data analyst.

Example: Count number of words in Google Sheets or Excel

COUNT NUMBER OF WORDS IN GOOGLE SPREADSHEET OR EXCEL

Convert month name to a number in Google Sheets or Excel

How to convert a month name to a number string in Excel or Google Sheets?

FORMULA

=MONTH(DATEVALUE(A2&" 1"))

=MONTH(DATEVALUE(A3&" 1"))

If you have the month name stored as a text and want to extract the month number, the formula below will help you extract it.

The formula is compatible with Excel and Google Spreadsheet and will work on both.

Below how the result will look.

CONVERT MONTH NAME TO NUMBER IN GOOGLE SHEETS OR EXCEL
CONVERT MONTH NAME TO NUMBER IN GOOGLE SHEETS OR EXCEL

Convert 1-12 to a month name in Google Sheets or Excel

How to convert 1-12 number into a month name in Excel or Google Sheets?

FORMULA

=TEXT(A2*29,"mmmm")

=TEXT(A3*29,"mmm")

If you have the month name stored as a number ranging from 1-12 and want to extract the month name, the formula below will help you extract it.

The formula is compatible with Excel and Google Spreadsheet and will work on both.

Below how the result will look.

CONVERT 1-12 TO MONTH NAME IN GOOGLE SHEETS OR EXCEL
CONVERT 1-12 TO MONTH NAME IN GOOGLE SHEETS OR EXCEL

Convert letter to a number in Google Sheets or Excel

How to convert an alphabet into a number string in Excel or Google Sheets?

FORMULA

=COLUMN(INDIRECT(A2&1))

If you want to convert an alphabet to a number this formula will help you extract the exact position of a given letter. For example, A has 1 and H has 7 position

The formula is compatible with Excel and Google Spreadsheet and will work on both.

Below how the result will look.

CONVERT CONVERT LETTER TO NUMBER IN GOOGLE SHEETS OR EXCEL
CONVERT CONVERT LETTER TO NUMBER IN GOOGLE SHEETS OR EXCEL