I would like to be able to remove a string of text in a cell that appears after an '&' symbol in a cell.

I cant use the LEFT or RIGHt function as the '&' Symbol is a different places in each cell.

Any ideas on a method?

Regards BVG