microsoft_excel:trim
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.
microsoft_excel/trim.txt · Last modified: 2022/07/01 08:24 by 45.89.242.238