| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to remove duplicate text with comma seperated
Hello,
Function NoDupe(r As Range) As Variant Dim rC As Variant, obj As Object Set obj = CreateObject("Scripting.Dictionary") For Each rC In Split(r, ",", -1) obj.Item(rC) = rC Next rC NoDupe = Join(obj.keys, ",") Set obj = Nothing End Function Regards, Bernd |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to remove duplicate text with comma seperated
Thank Guys..
It's work find. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to remove duplicate text with comma seperated | Excel Programming | |||
| Check if text box has more than one entry seperated by a comma | Excel Programming | |||
| Importing Text File with Comma Seperated Data - Need Help Pls | Excel Discussion (Misc queries) | |||
| How to split a value seperated by comma? | Excel Discussion (Misc queries) | |||
| Importing Comma Seperated Text Please Help ? | Excel Discussion (Misc queries) | |||
Linear Mode
