This use is simple, but not intuitive because you must add the TEXT() function. Let’s look at another use that might not occur to you. How to ignore characters when using TEXTSPLIT() in Excel ...

There are mainly two ways to remove the formula in Excel and keep the text. No matter how many formulas you have used in your spreadsheet, you can delete or hide them without removing the values.

The article describes how to ignore zeros in a formula by using Excel's AVERAGEIF function ... If the argument is completely blank or contains only text values, AVERAGEIF also returns the # ...

TEXTSPLIT() is a Text function in Excel. The purpose of this function ... cell is created between the resultant values since the ignore_empty argument is not specified. So Excel is taking its ...