How to remove consecutive number string only from a column ?

[sezuh]

Hi,
I have a list of number string and I would like to remove the one with consecutive numbers onlyand paste it to next column.I don’t mind if its excel formula or UDF.Any suggestion or help would be much appreciated in advance.
Here is an example.

[TABLE="width: 316"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]LIST[/TD]
[TD="colspan: 2"]EXPECTED RESULT[/TD]
[/TR]
[TR]
[TD]16 27 33 37[/TD]
[TD]16 27 33 37[/TD]
[TD]18 19 20 21[/TD]
[/TR]
[TR]
[TD]18 19 20 21[/TD]
[TD]01 19 20 32[/TD]
[TD]36 37 38 39[/TD]
[/TR]
[TR]
[TD]01 19 20 32[/TD]
[TD]08 26 32 39[/TD]
[TD]01 02 03 04[/TD]
[/TR]
[TR]
[TD]08 26 32 39[/TD]
[TD]13 14 24 25[/TD]
[TD]34 35 36 37[/TD]
[/TR]
[TR]
[TD]36 37 38 39[/TD]
[TD]03 04 30 31[/TD]
[TD]18 19 20 21[/TD]
[/TR]
[TR]
[TD]13 14 24 25[/TD]
[TD]05 20 30 32[/TD]
[TD]33 34 35 36[/TD]
[/TR]
[TR]
[TD]03 04 30 31[/TD]
[TD]06 25 36 38[/TD]
[TD]10 11 12 13[/TD]
[/TR]
[TR]
[TD]01 02 03 04[/TD]
[TD]12 13 28 31[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]34 35 36 37[/TD]
[TD]01 04 17 19[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]05 20 30 32[/TD]
[TD]09 31 36 38[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18 19 20 21[/TD]
[TD]27 28 33 34[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]06 25 36 38[/TD]
[TD]08 09 19 33[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]12 13 28 31[/TD]
[TD]02 06 24 33[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]01 04 17 19[/TD]
[TD]13 30 33 35[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]09 31 36 38[/TD]
[TD]19 21 27 35[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]33 34 35 36[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]27 28 33 34[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]08 09 19 33[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]10 11 12 13[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]02 06 24 33[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]13 30 33 35[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]19 21 27 35[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

Thanks again

 

[Lukhanyo]

Thanks for the reply.

Message #1 was an example used for someone else.

At this point I cannot insert the Spreadsheet for you to examine. May I, please have permission to have your email via the Direct message, and attach the spreadsheet that is showing no results despite the changes in the VBS code?

Thank you, it would be very kind of you to assist.

Regards,
Lukhanyo

 

[JLGWhiz]

The code is only valid for a list of numbers formatted as shown in the OP. If you have number groupings in a differerent format than the 2 digit, 4 sets per cell, then the code will not apply to the different format. If you can explain, or illustrate any variations to the format shown in the OP, the code can probably be modified to accomodate the variations.