Trim Spaces With Cells
With this tool it is possible to remove extra spaces at the beginning and at the end of cells containing data (leading and trailing spaces).
It also works on those apparently empty cells but that, in real terms, contain white spaces invisible for the user.
It is very useful for the data sheet cleansing since Report Inverter, works with tools that use a data patterns from the datasheet as a reference, being such a thing a major issue considering empty or non empty cells.
|