How to remove duplicates within a "single cell"

Hi all-

I have a spreadsheet I'm working on where I pasted the values and it caused duplicate values to appear in the same cell. Here is an example below of what it looks like:


I want to remove the duplicate values within the cell so it just shows:


I've tried using the different VBA macro's around the internet but they don't seem to work for this issue. I can't use the Text to Columns either since that won't help in separating out the values.

Can you help me?

How about
=LEFT(A2,LEN(A2)/2)

Use the blow formula:

=MID(B2&" ",1,FIND(" ",B2&" "))& MID(SUBSTITUTE(B2&" ",MID(B2&" ",1,FIND(" ",B2&" ")),"")&" ",1, FIND(" ",SUBSTITUTE(B2&" ",MID(B2&" ",1,FIND(" ",B2&" "))&" ","")))

Just replace B2 with your required cell.

Using the above formula we will able to avoid duplicated text in any position of the sentence in the cell.

I am looking for the same solution . . .

I tried arup1032's solution, and a spreadsheet showing the result is attached.

It is truncating non-duplicate words . . .

Any and all help is greatly appreciated. Thanks.View attachment chartEx.xlsx

You have hijacked another member’s thread. Please start your own. Thanks.