Remove Blank Spaces Filter (table)
What is it?
The Remove Blank Spaces filter can be used to clean up the output of your data – especially when capturing data within a sentence or adjacent to a field that contains spaces.
How is it used?
Add Table Filter > Format Cell Content > Remove Blank Spaces
After adding a Remove Blank Spaces filter, there are three options to choose from “Trailing Blank space” which removes multiple blank spaces from the beginning or end of your text, “All Blank Spaces” removes every space, and finally “Multiple Blank Space” that only removes spaces when two or more occur anywhere in the text. This filter is very similar to the simple text version but gives the option to specify one or all columns.