Hey thats brilliant thanks. Not had a chance to put it in my larger spreadsheet yet but I'll try it today.

Unfortunately my supplier data feeds are inconsistent and that is half my problem. Trying to get around those issues as well. Maybe it would work if we forced a column to be consistent by either removing or inserting spaces based on rules?

The 2nd part doesn't need column F sorted before data stripping as my sheet is already sorted in a particular order. If you could provide the 2nd part that would be amazing!!!



Many Thanks
Dave