All resources related to TEXT for Excel and Google Sheets.

Cell contains number

Excel allows a user to check if a cell contains a number by using the COUNT and FIND functions. This step by step tutorial will assist all levels of Excel users in checking if a cell contains any number. Figure 1. The result of the COUNT and FIND functions Syntax...

How to Count Total Words in a Cell

We can use a formula that combines the LEN, TRIM, and SUBSTITUTE functions to count the total words in a cell. The steps below will walk through the process. Figure 1: Count of Total Words in Cells of Column B General Formula =LEN(TRIM(A1))-LEN(SUBSTITUTE(A1," ",""))+1 A1 represents the cell of interest....

How to Use the Excel CODE Function

We can use the Excel CODE FUNCTION to return a numeric code for a given character. The CODE function generates a numeric code for the first character in a text string. The code is based on the character set used by our computer. The steps below will walk through the process....

Excel RIGHT Function

Excel allows us to get a certain number of character from a string from the right side, by using the RIGHT function. This step by step tutorial will assist all levels of Excel users in getting characters from the right side. Figure 1. The result of the RIGHT function Syntax...

Count keywords cell contains

Excel allows a user to count keywords which a cell contains using the SUMPRODUCT, ISNUMBER and SEARCH functions. This step by step tutorial will assist all levels of Excel users to count keywords cell contains. Figure 1. The result of the formula Syntax of the SUMPRODUCT Formula The generic formula...

Split Dimensions into Two Parts

Excel allows a user to split dimensions into two parts using several functions: SUBSTITUTE, RIGHT, LEFT, FIND and LEN. This step by step tutorial will assist all levels of Excel users to get the dimensions without units and to extract each dimension in the separate column. Figure 1. How to...

Strip non-numeric characters

Excel allows us to strip non-numeric characters from the string by using several Excel functions: TEXTJOIN, IFERROR, MID, ROW and INDIRECT. This step by step tutorial will assist all levels of Excel users in extracting the numeric characters from the text. Figure 1. Remove non-numeric characters from the text Syntax...

Excel LEFT Function

Excel allows us to get a certain number of characters from the beginning of the text, using the LEFT function. This step by step tutorial will assist all levels of Excel users in using the LEFT function. Figure 1. The result of the LEFT function Syntax of the LEFT Formula...

Excel REPLACE Function

Excel has some very effective ways to fix errors on spreadsheets. The REPLACE function in Excel can replace text with new ones. It replaces characters with given location from a string with new text. In this tutorial, we will learn how the REPLACE function works in Excel. Figure 1. Example...

Cell equals one of many things

Excel allows a user to check if a cell is equal to one or many things from a range, using the SUMPRODUCT function. As a result, we get True or False. This step by step tutorial will assist all levels of Excel users in checking if a cell is equal...