====== Microsoft Excel - Trim ====== The standard TRIM function in EXCEL only removes soft spaces (ASCII 32) but not non-breaking spaces (ASCII 160) which is often the case from pastes from the web. =TRIM(SUBSTITUTE(C2, CHAR(160), CHAR(32))) **NOTE:** Also check for embedded tabs that might be utilizing the same formula but replacing ASCII code 160 with 9. ----