Google Sheets Text Functions

Google Sheets BAHTTEXT Function

This post will guide you how to use Google Sheets BAHTTEXT function with syntax and examples. Description The Google Sheets BAHTTEXT function Converts a number to Thai text with the suffix Baht for integer values and Satang for decimal values. The BAHTTEXT function is a build-in function in Google Sheets and it is categorized as a Text… read more »

Google Sheets TEXTJOIN Function

This post will guide you how to use Google Sheets TEXTJOIN function with syntax and examples. Description The Google Sheets TEXTJOIN 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 empty… read more »

Google Sheets VALUE Function

This post will guide you how to use Google Sheets VALUE function with syntax and examples. Description The Google Sheets VALUE function converts a text string that represents a number to a numeric value. The VALUE function can be used to converts a text string in the date, time or number formats into a numeric… read more »

Google Sheets UPPER Function

This post will guide you how to use Google Sheets UPPER function with syntax and examples. Description The Google Sheets UPPER function converts all characters in text string to uppercase. The UPPER function can be used to convert a given text string to uppercase letters in google sheet. And you need to know that numbers,… read more »

Google Sheets UNICODE Function

This post will guide you how to use Google Sheets UNICODE function with syntax and examples. Description The Google Sheets UNICODE function returns the decimal Unicode value of the first character of the text. The UNICODE function can be used to return a number corresponding to a Unicode character in google sheets.  The purpose of… read more »

Google Sheets UNICHAR Function

This post will guide you how to use Google Sheets UNICHAR function with syntax and examples. Description The Google Sheets UNICHAR function returns the Unicode character for a given number. This function support to return characters in both the UTF-8 and UTF-16 character set. The UNICHAR function can be used to returns a Unicode character… read more »

Google Sheets TRIM Function

This post will guide you how to use Google Sheets TRIM function with syntax and examples. Description The Google Sheets TRIM function removes all spaces from text string except for single spaces between words.  You can use the TRIM function to remove extra spaces between words in a string. Or removes leading and trailing spaces… read more »

Google Sheets TEXT Function

This post will guide you how to use Google Sheets TEXT function with syntax and examples. Description The Google Sheets TEXT function converts a numeric value into text string with a specified format. The TEXT function can be used to convert a number formatted as text according to a specified format in google sheets.  The… read more »

Google Sheets T Function

This post will guide you how to use Google Sheets T function with syntax and examples. Description The Google Sheets T function returns the text referred to by value. You can use T function to remove values that are not text. The T function can be used to return text when given a text value… 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 SPLIT Function

This post will guide you how to use Google Sheets SPLIT function with syntax and examples. Description The Google Sheets SPLIT function used to divide text string around a specified character or delimiter and put each separate pieces into a separate cell in the row. The SPLIT function can be used to divide a text… read more »

Google Sheets SEARCHB Function

This post will guide you how to use Google Sheets SEARCHB function with syntax and examples. Description The Google Sheets SEARCHB function returns the number of the starting location of a substring in a text string counting each double-character as 2. You can use the SEARCHB function to locate a text string within another text… read more »

Google Sheets SEARCH Function

This post will guide you how to use Google Sheets SEARCH function with syntax and examples. Description The Google Sheets SEARCH function returns the number of the starting location of a substring in a text string. You can use the SEARCH function to locate a text string within another text string and returns the position… read more »

Google Sheets ROMAN Function

This post will guide you how to use Google Sheets ROMAN function with syntax and examples. Description The Google Sheets ROMAN function converts a given number to a Roman numeral as text result. The ROMAN function can be used to format a number in Roman numerals in google sheets. And it’s returned value as a… read more »

Google Sheets RIGHTB Function

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

Google Sheets RIGHT Function

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

Google Sheets REPT Function

This post will guide you how to use Google Sheets REPT function with syntax and examples. Description The Google Sheets REPT function repeats a text string a specified number of times. The REPT function can be used to repeat specified text repeated a number of times in google sheets. And it’s return value as the… 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 REGEXREPLACE Function

This post will guide you how to use Google Sheets REGEXREPLACE function with syntax and examples. Description The Google Sheets REGEXREPLACE function is to replace a part of a text string with a different substring using regular expressions. The REGEXREPLACE function can be used to replace a substring from a text string according to a… read more »

Sidebar