google sheets text - Free Excel Tutorial

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 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 »

Google Sheets REGEXMATCH Function

This post will guide you how to use Google Sheets REGEXMATCH function with syntax and examples. Description The Google Sheets REGEXMATCH function is to check whether a piece of text matches a regular expression. The REGEXMATCH function can be used to check whether a substring from a text string matches a given regular expression in… read more »

Google Sheets REGEXEXTRACT Function

This post will guide you how to use Google Sheets REGEXEXTRACT function with syntax and examples. Description The Google Sheets REGEXEXTRACT function uses a regular expression to extract the first matching substring. The REGEXEXTRACT function can be used to extract the first matching substring from a text string according to a given regular expression in… read more »

Sidebar