Get How To Remove Extra Space In Excel Table Pictures. It removes all extra spaces from text except a single space between words in excel. Leading and trailing spaces in excel often leads to a lot of frustration.

Here's what the numbers look like:

The trim function then takes over to remove extra spaces and returns the final text. I had assumed that the spaces were present in the excel sheet and copied over experienced the same problem. In this particular example, we have data obtained from keyword planner tool by google. Remove spaces and line breaks from cells.