Learn Microsoft Excel Online Free
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
