Hi, I have a table which has been imported from a web query, which has a
column of ID numbers contained in it. Some of these (not all) are not
being picked up as numbers by Excel, and the reason appears to be the
inclusion of a leading nonbreaking space character. There is a way to
clean these up by using the trim and substitute functions in a separate
column, but as I will be refreshing this query reasonably frequently and
the size of the range will change each time, I would like to come up
with a VBA solution to automate removing the leading nonbreaking space.
Any assistance would be welcomed.

Thanks in advance