Excel Demo
Excel Sheet Usage Instructions
Interactive Excel Sheet
1- Trim with SUBSTITUTE Formula in B Cells: =TRIM(SUBSTITUTE(A2, CHAR(160), " ")) 2- Enter some text from web or that contains non-ASCII spaces in A2 to A3 cells 3- You may also download the Excel sheet by using the first icon towards right bottom. The downloaded sheet contains formulas for respected cells.