📩: [email protected]: [email protected]: [email protected]

 

When The TRIM Function Doesn’t Work

When The TRIM Function Doesn’t Work

by | Jun 2, 2023 | BASIC EXCEL

Invisible characters are a great threat to accurate results when working with texts. Trim functions work well to remove Char(32) [spaces] but not Char(160) [non-break space] characters. The solution to cleaning non-break spaces is using the SUBSTITUTE function....