TEXT Articles: Excel and Google Sheets

We can use the excel CHAR function to return a character once we supply a valid character code. This is useful for specifying characters that are difficult to enter in a formula. This article will walk through the process of using the CHAR function. Figure 1: Result and Comment after...

Figure 1. Replace One Character With Another in Excel. If our aim is to replace/switch one character with a different one in Excel, we have to utilize the SUBSTITUTE function. Generic Formula =SUBSTITUTE(ref,old,new) We can replace a specific text in a given string by using the SUBSTITUTE formula. How to...

While working with Excel, we are able to convert any text into a numeric value by using the VALUE function.  This step by step tutorial will assist all levels of Excel users in the usage and syntax of the VALUE function.   Figure 1. Final result:  Excel VALUE function Syntax...

While working with Excel, we are able to convert any text string into capital letters by using the UPPER function.  UPPER function converts text into capital letters or uppercase.  This step by step tutorial will assist all levels of Excel users in the usage and syntax of the UPPER function....

Excel allows us to join the text with a defined delimiter by using the TEXTJOIN function with an ability to avoid empty cells. This step by step tutorial will assist all levels of Excel users in concatenating values in the table with a defined delimiter. Figure 1. The final result...

While working with Excel, we are able to join two or more text strings into one by using the CONCATENATE function.  This step by step tutorial will assist all levels of Excel users in the usage and syntax of the CONCATENATE function.   Figure 1. Final result:  Join text strings...