It counts the spaces as characters ... Also read: How to convert currencies in Excel. What is an example of a text function? The TEXT function in Excel is used to join a formatted number with ...

This is a useful function to split text strings that contain multiple spaces, commas, or a mix of different delimiters. The TEXTSPLIT() function is a new feature that is available only in Excel ...