Excel TRIM Function Tips

There are times when you bring data from other software to excel sheets and find that some of the numbers are formatted as text

The TRIM formula introduced by Microsoft Excel allows us to remove all the unwanted spaces that are present within a text, other than any singular spaces in between different words.

We often see numbers stored in Excel as text which leads to wrong calculations, especially while using the cells in the functions i.e.

At first instance, you may wonder why we would need to remove spaces in Excel. If you have unnecessary spaces it may prevent working of some functions, filtering etc.