Hi All

I want to adapt your code for my worksheet.

The data was run through SPSS so everything is merged eg "Fanta Strawberry 40 ml" is now "FantaStrawberry40ml"

What would be the code to merge everything in a cell? May even be just a function.

ie Current = "Fanta Strawberry 40 ml"
Expected = "FantaStrawberry40ml"

Thanks