+= Windows XP =  +  +=== Replace Non-Standard Space Characters ===  +  +The ASCII code for non-breaking space is 160 and along with other chars like 202 which look like space but have different ASCII values cause very frustrating problems for formulas using functions like SUBSTITUTE(). Additionally functions like CLEAN() do not detect these CHARs as they are technical valid within the extended ASCII code set. Fortunately we can replace them with space or other delimiters using the SUBSTITUTE() function in combination with the CHAR() function.  +  + =SUBSTITUTE(SUBSTITUTE(B2, CHAR(202), CHAR(32)), CHAR(160), CHAR(32))  +  +In most cases it will likely be easier to clean the data in bash using tr, sed, and awk. The example below replaces carriage returns with newline and removes all non essential ASCII characters using their respective ASCII codes. Characters can be deleted or replaced by utilizing the -d command parameter. Dive Deeper: https://alvinalexander.com/blog/post/linux-unix/how-remove-non-printable-ascii-characters-file-unix  + <pre> <pre>
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 35 bytes) in /www/ljackson.us/wiki/htdocs/includes/DifferenceEngine.php on line 1614