

HLOOKUP Range Lookup Table with Absolute References
Roman Kondtratiuk
TRIM can remove all spaces from cells containing text except for single spaces between words.
Efficiently “cleanse” text received from an external application or database that may have irregular text spacing.