google sheets text - Free Excel Tutorial

Add Leading Zeros in Google Sheets

To pad a number with zeros, you need to add leading spaces and/or carriers. For example, if the original digit contains 2 digits, three additional characters will be added on before it. If there are 3 digits in total, allocating two places for these extra pieces of information ensures that your output looks correct without… 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 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