excel tip

Remove spaces with TRIM

TRIM is a useful function known by few people. It removes any spaces at the beginning of a value. This is useful if you are pulling in values from somewhere else.