Thanks for that Pauley,
Could you please help me with how to use that code?

I was thinking of a VBA macro that would go through all the cells in the column, (but the site won't let me edit my question...)