is there anyone who help me in macro ??

[Ejaz]

I have a list of phone number i.e. 03333000001 To 03333999999. (data type text)

Required

I want to filter & copy number from above phone number list,

In first attempt extract/copy hiest repeat digit number like 03333333333
In first attempt extract/copy hiest repeat digit number like 03333333331
In first attempt extract/copy hiest repeat digit number like 03333333312
In first attempt extract/copy hiest repeat digit number like 03333333322
In first attempt extract/copy hiest repeat digit number like 03333333433
In first attempt extract/copy hiest repeat digit number like 03333333555
In first attempt extract/copy hiest repeat digit number like 03333334333
on so on

 

[taigovinda]

What are you trying to achieve, exactly? A sorted list of unique values?