The data is imported from another source like this:
48 Limestone St.Markham, ON L6B0P6 (no space after St.)
When applying Wrap Text it shows up as:
48 Limestone St.
Markham, ON L6BOP6
When I use =Left(cell, 18) or =left(cell,17) I note that the result is the same - 48...