Remove consecutive numbers

[Lukhanyo]

Hello Guys,

I saw this post here: https://www.mrexcel.com/forum/excel...ve-consecutive-number-string-only-column.html

On how to remove consecutive numbers in a row, when I apply its suggestions I do not get any results.

I am new to VBN, can anyone help me with a step-by-step guide on how to achieve the result?

Kind regards.
Lukhanyo

 

[Rick Rothstein]

Hello Guys,

I saw this post here: https://www.mrexcel.com/forum/excel...ve-consecutive-number-string-only-column.html

On how to remove consecutive numbers in a row, when I apply its suggestions I do not get any results.

I am new to VBN, can anyone help me with a step-by-step guide on how to achieve the result?

Kind regards.
Lukhanyo

The original data are the first four numbers per row (the other numbers per row are the results from the code). What may be tripping you up is the four numbers on each row are all in a single cell with a single space between them. So, the first four numbers are in cell A1 (space delimited), the four numbers under them are in cell A2 (space delimited) and so on. If you run the code on the number list set up that way, then it should work for you.