Remove unnecessary spaces

Please sign up for the course before starting the lesson.

A common cause of Excel problems are unwanted spaces in cells. The most troublesome are spaces at the end of cells because you can't see that they are there.

There is a function to remove all spaces at the beginning and end of the cell as well as any double spaces between characters (so it will leave a single space).

Remove unwanted spaces

To see the full course contents click here.

Back to: Intermediate Excel Course > Text Functions