google sheets value - Free Excel Tutorial

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