Remove duplicates based on specific words

[coatesy69]

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

[Beamernsw]

Hi Graham, Merry Christmas, try this formula assuming that "Brown Sofa - RRP £250" was in cell A1 and copy down.

Please Login or Register  to view this content.

[mehmetcik]

Hi Graham

This is quite simple really, well not really

We count how many times RRP appears in our String, and replace the second occurrance with |

Then we delete the | and everything after it.

Please Login or Register  to view this content.

Paste in row 1, any cell but A1 and fill down

[BadlySpelledBuoy]

Another method:

Please Login or Register  to view this content.

BSB

[coatesy69]

Amazing.
Thank you so much for this help.
Hope you have a great Christmas and a happy New Year.

Graham