Google Sheets Functions

Google Sheets PROPER Function

This post will guide you how to use Google Sheets PROPER function with syntax and examples. Description The Google Sheets PROPER function capitalizes the first character in each word of a text string and set other characters to lowercase . The PROPER function can be used to capitalize each word in a specified text string… read more »

Google Sheets MIDB Function

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

Google Sheets MID Function

This post will guide you how to use Google Sheets MID function with syntax and examples. Description The Google Sheets MID function returns a substring (a specified number of the characters) starting from the middle of a text string. The MID function can be used to extract a given number of characters from the middle… read more »

Google Sheets LOWER Function

This post will guide you how to use Google Sheets LOWER function with syntax and examples. Description The Google Sheets LOWER function converts all characters in a text string to lowercase. The LOWER function can be used to convert a given text string to lowercase letters in google sheet. And you need to know that… 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 LEFT Function

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

Google Sheets JOIN Function

This post will guide you how to use Google Sheets JOIN function with syntax and examples. Description The Google Sheets JOIN function joins two or more text strings together and separated by a delimiter. you can select an entire range of cell references to be combined in Google Sheets. and you can also specify an… read more »

Google Sheets FIXED Function

This post will guide you how to use Google Sheets FIXED function with syntax and examples. Description The Google Sheets FIXED function rounds a number to the specified number of decimal places and returns the result as text string and not a number. The FIXED function can be used to format a number to text… 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 »

Google Sheets EXACT Function

This post will guide you how to use Google Sheets EXACT function with syntax and examples. Description The Google Sheets EXACT function compares if two text strings are the same and returns TRUE if they are the same, Or, it will return FALSE. The EXACT function can be used to test whether two given text… read more »

Google Sheets DOLLAR Function

This post will guide you how to use Google Sheets DOLLAR function with syntax and examples. Description The Google Sheets DOLLAR function converts a number to text using currency format (such as: $ symbol), the currency format used depends upon your default language setting on your computer. The DOLLAR function can be used to convert… read more »

Google Sheets CONCATENATE Function

This post will guide you how to use Google Sheets CONCATENATE function with syntax and examples. Description The Google Sheets CONCATENATE function combines 2 or more strings or ranges together. The CONCATENATE function can be used concatenate text strings, cells, ranges, columns and rows in google sheets. It joins multiple values and returns the result… read more »

Google Sheets CODE  Function

This post will guide you how to use Google Sheets CODE  function with syntax and examples. Description The Google Sheets CODE function returns the numeric Unicode map value for the first character of a text string. And you can get the Unicode table online at the Unicode website. The CODE function can be used to… read more »

Google Sheets CLEAN Function

This post will guide you how to use Google Sheets CLEAN function with syntax and examples. Description The Google Sheets CLEAN function removes all non-printable characters from a text string. The CLEAN function can be used to take a text string and returns text that has been removed all other non-printable characters, such as line breaks…. read more »

Google Sheets CHAR Function

This post will guide you how to use Google Sheets CHAR function with syntax and examples. Description The Google Sheets CHAR function returns the character specified by a number (ASCII Value) according to the current Unicode table. And you can get the Unicode table online at the Unicode website. The CHAR function can be used to… read more »

Sidebar