Tag: SUBSTITUTE formula

When working with Excel, we often need to manipulate text strings, such as calculating the length of a text with and without spaces. This is where the LEN and SUBSTITUTE