find certain text in a string and split into a new column

Hi,

Excel.PNG

Hi, i want to split the string in column A to only show the numbers separated by a comma with removing duplicates. All the ID's start with 1080..

this is what i have tried so far...

Please Login or Register  to view this content.

The wild card 1080* doesn't work in InStr. The output should show as the values in the above picture attached.

Thanks,

Can you post a sample sheet? I can't receive pictures for some reason.

TestSq.xlsx

Thanks,

Here's how I read your problem.

Please Login or Register  to view this content.

Thanks Jindon.

Can you explain me how this code works??

1) Extract all numbers that is 1080 + 5digits.
2) Delete duplicates.