Operations in Google Sheets
Google Sheets
How to Remove Substring in Google Sheets (With Example)
You can use the following formulas to remove specific substrings from cells in Google Sheets:
Method 1: Remove One Substring from Cell
=SUBSTITUTE(A2,"this_string","")
Method 2: Remove Multiple...
Google Sheets
Google Sheets: How to Convert Time Duration to Minutes
You can use the following formula to convert a time duration to minutes in Google Sheets:
=VALUE(B2*24*60)
This particular formula converts the time duration in cell...
Google Sheets
Google Sheets: How to Convert Time Duration to Seconds
You can use the following formula to convert a time duration to seconds in Google Sheets:
=VALUE(B2*24*3600)
This particular formula converts the time duration in cell...
Google Sheets
How to Calculate Day of the Year in Google Sheets
You can use the following formulas to calculate the day of the year in Google Sheets:
Formula 1: Calculate Day of the Year for Today
=TODAY()-DATE(YEAR(TODAY()),1,0)
This...
Google Sheets
Google Sheets: Conditional Formatting Between Two Values
You can use the custom formula function in Google Sheets to apply conditional formatting to cells that have a value between two specific values.
The...
Google Sheets
Google Sheets: How to Extract Last Word from Cell
You can use the following syntax to extract the last word from a cell in Google Sheets:
=TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",LEN(A2))),LEN(A2)))
This particular formula will extract the...
Google Sheets
How to Generate Random Dates in Google Sheets
You can use the following basic syntax to generate a random date between two dates in Google Sheets:
=TO_DATE(RANDBETWEEN(DATE(2015,1,1),DATE(2022,12,31)))
This particular formula will generate a...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read