Forum Discussion
Number format
As a Realtor I have, over the years, downloaded bulk MLS data for offline processing in Excel for the benefit of my buyer and seller clients. There was never a problem until the MLS service (Garden S...
Still no luck. Tried substitute...SUBSTITUTE(D2,CHAR(160),"")...and clean and the text was still unworkable.
You were close. Substitute produces text so the trick is to multiply the result by 1, see attached.
- I clicked on the formula bar and noticed there was some character behind the numbers. Then I used =code(right(a1, 1)) to get the ascii code
It's on the last place. You may stay on the cell, click on formula bar and you'll see it's one more character here. Which one you could check by
=CODE(RIGHT(D2))Appearing of non-breaking space is the usual story with copy/pasting data from web and in some other cases. That's just experience which JKPieterse has much more than many of us.
