I have found the issue once more.
It looks like it also has non-breaking space characters that are not seen with the trim function.
Here is the code that will work:
Application.DisplayAlerts = True
Application.EnableEvents = True
If Application.Calculation = xlCalculationManual Then
MsgBox "Calculation was OFF will be turned ON upon completion"
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Dim cell As Range
Selection.Replace What:=Chr(160), Replacement:=Chr(32), _
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False
On Error Resume Next
For Each cell In Intersect(Selection, _
cell.Value = Application.Trim(cell.Value)
On Error GoTo 0
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
The instructions for enabling visual basic and the editing window are found here: http://www.techonthenet.com/excel/macros/visual_basic_editor2011.php
After you run that code for the chosen cells, it will work.