google sheets find - Free Excel Tutorial

Count Cells that are Case Sensitive in Google Sheets

If you are a frequent user of Google Spreadsheets, you may have come across situations where you needed to add or count the cells that were case-sensitive. If you have done this task manually, I would like to point out that it is the most inefficient way to do it, particularly when Google Spreadsheets has… read more »

Google Sheets SUBSTITUTE Function

This post will guide you how to use Google Sheets SUBSTITUTE function with syntax and examples. Description The Google Sheets SUBSTITUTE function replaces a new text string for an old text string in a text string. The SUBSTITUTE function can be used to replace existing text with new text in a string in google sheets. … read more »

Google Sheets REPLACEB Function

This post will guide you how to use Google Sheets REPLACEB function with syntax and examples. Description The Google Sheets REPLACEB function replaces all or part of a text string with another text string based on a number of bytes. The REPLACEB function can be used to replace characters specified by position in the given… read more »

Google Sheets REPLACE Function

This post will guide you how to use Google Sheets REPLACE function with syntax and examples. Description The Google Sheets REPLACE function replaces all or part of a text string with another text string. The REPLACE function can be used to replace characters specified by position in the given text string with another newly text… read more »

Google Sheets LENB Function

This post will guide you how to use Google Sheets LENB function with syntax and examples. Description The Google Sheets LENB function returns the length of a text string in bytes. The LENB function can be used to count the number of bytes of a given text string including space or nonprint characters in google… read more »

Google Sheets LEN Function

This post will guide you how to use Google Sheets LEN function with syntax and examples. Description The Google Sheets LEN function returns the length of a text string (the number of characters in a text string). The LEN function can be used to count the number of characters for a given text string in… read more »

Google Sheets LEFTB Function

This post will guide you how to use Google Sheets LEFTB function with syntax and examples. Description The Google Sheets LEFTB function returns a substring (a specified number of the bytes) from a text string, starting from the left portion. The LEFTB function can be used to extract the left portion of a string up… read more »

Google Sheets FINDB Function

This post will guide you how to use Google Sheets FINDB function with syntax and examples. Description The Google Sheets FINDB function returns the position of the first text string (sub string) within another text string counting each double-character as 2. The FINDB function can be used when you want to get the position of… read more »

Google Sheets Find Function

This post will guide you how to use Google Sheets FIND function with syntax and examples. Description The Google Sheets FIND function returns the position of the first text string (sub string) within another text string. The FIND function can be used when you want to get the position of a sub string inside another… read more »

Sidebar