Merry Christmas all.

If there is anyone out there who could help me it would be much appreciated.

Is there a way to remove duplicate words from a cell and anything after it.

If there are multiple products for sale. Some have RRP's, some don't. But some have an RRP twice which might have a different value to the first one listed.

EG.

Brown Sofa - RRP £250
Red Sofa
Blue Sofa - RRP £250 RRP £249

Is there a way to remote the duplicated word RRP and any text after it.

Thanks for looking

Graham