Removing unnecessary blank spaces in text records
Blank spaces can be present before and after the content from each cell.
They are more likely to be present in columns containing data manually entered by someone, such as a name or a phone number. These spaces are shown as grey squares.
Procedure
Results
Information noteTip: This transformation can also be performed by using the Automatically formatting data based on examples function.