Clean 01)

Trim Leading and Trailing Blanks From Selected Cells

Trims all spaces from a text field except for spaces between words.

Typically used to remove trailing spaces in data imported from other sources. These spaces can be confusing to functions like VLOOKUP and will often cause unexpected results.


Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc