Removing duplicate text in a single line

Hey all -

So, here's the story -

I have many lines of text, split into rows. Several rows have a piece of information that is duplicating and I want to keep the first instance, but remove the rest.

Example:
Row 1: Jiojo GGHH jfioj GGHH jiojio.
Row 2: Bdejjjfeij GGHH ufuheuuihuifhiue GGHH fjiofjwefjoii GGHH
Row 3: Njidiikwl ojdijo idjwoji GGHH jiojooj GGHH ffjwofw.

Basically, I'm looking for a way to remove all but one instance of GGHH only per row.

Someone else already provided a code that works well for removing duplicates in a row, but I need to customize it to only remove instances of say, GGHH and leave the rest of the text alone.

Here's the code provided:

Please Login or Register  to view this content.

If anyone has any suggestions, I would be grateful!!

Thanks!

Try this: (untested, but should work)

Please Login or Register  to view this content.

UDF

Use in cell like

=RemoveDupsFromCell(A1,"GGHH")

Please Login or Register  to view this content.

Use mine as a UDF:

Please Login or Register  to view this content.

Put in a cell : =Excelforum(A1, "GGHH")
(where A1 is whatever cell you're trying to remove duplicates from)

BY default.. if information is duplicated in a string... I would not think that it needs to make a proper 'English' sentence (unless very poor grammar)..?? therefore.. going on that.. assuming you don't care where the duplicate value is shown in the resultant string.. try:

Please Login or Register  to view this content.