all those have char(160) after them use find replace
in find put alt+0160 (you must use the numeric key pad to type 0160)
replace with nothing
reenter the formula
or in col b put
=--SUBSTITUTE(A2,CHAR(160),"") fill down copy paste over original clear col b
also calculation on your workbook seems to be set to manual