remove duplicates word in single cell

**iwanttoexcelinexcel** · 09-24-2015, 01:43 PM

for example
BOSCH Wiper Refill For: Mercedes S Class Mercedes S500 140 Chassis 2006

result should be
BOSCH Wiper Refill For: Mercedes S Class S500 140 Chassis 2006

Thanks and appreciate all response.

**zbor** · 09-24-2015, 02:03 PM

Use this UDF same as any other formula as here in B column:

=SINGLESTRING(range)

This will create only unique words in it.

**iwanttoexcelinexcel** · 09-24-2015, 02:23 PM

Thanks

remove duplicates word in single cell

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

remove duplicates word in single cell

Re: remove duplicates word in single cell

Re: remove duplicates word in single cell

Thread Information

Users Browsing this Thread

Similar Threads

"Remove Duplicates" not working on a list unless I paste back and forth from Word.

[SOLVED] Remove duplicates from single cell

Remove Duplicates and Multiple Rows into Single Cell with Commas.

[SOLVED] Remove duplicates in a single cell

[SOLVED] Concatenating values from a single column to remove duplicates in another.

remove entire row based on duplicates from single column

[SOLVED] Remove complete row containing a single word

Bookmarks

Bookmarks

Posting Permissions