Mitch you were right, once I limited my range to just the one column it WAS a lot quicker. There are occurences of the text I need all over the place, but lucky for me they all start in the same column.

Si .... I will try out what you posted and let you guys know which I found quickest. Either way, both are already a lot better than what I had.

Watch this space ...