• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

To remove duplicate words within a cell

R

Ramanan Arumugam

New Member
Hi,

Im trying to remove duplicate words within a cell. Even if the word repeats more than twice or thrice, etc., the output should be once. I have attached the result in green shaded in the sample file.

WS function or UDF is fine.

Please help me out.
 

Attachments

  • Scenario - Duplicate free cell.xlsx
    9.3 KB · Views: 15
Hi, Ramanan Arumugam!
And what about removing the 2 "oo" from Goodlife or the 2 "tt" from Getty, or the 2 "u" from Untucked, and so on? Which is the criteria you'd use to differentiate those cases from GoodLifeGoodLife, for example?
Regards!
 
Hi Oldchippy,

We might have to tweak your formula a bit as this fails for the text like "GetGrandLookGetGrandLook".
 
I am looking for the same solution . . .

I have tried the solution by oldchippy. A spreadsheet showing the result is attached.

When there are dupes, it cuts off the last word and part of another. When there are no dupes, it shows #Value!, which is not a problem, since that column could be deleted, after correcting the dupes.

Any and all help is greatly appreciated. Thanks.
 

Attachments

  • chartEx.xlsx
    10.5 KB · Views: 3
r121a947
You should reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
How to get the Best Results at Chandoo.org
Start a new post every time you ask a question, even if the theme is similar.
 
You must log in or register to reply here.
Back
Top