Trim – Removes all spaces from text except for single spaces between words. This is good for data that contains irregular spacing. Let’s say that our accounts receivable system exports our invoicing information with extra spacing. It was probably programmed to hold spaces for future (larger) invoice numbers. Got to be optimistic 😉