Hello,
I am new to Excel VBA, I work as an engineer and use a lot of data in Excel.
I wish I could simplify some of the work by opening this thread.
This may be very simple, but I can't seem to find a way.
Given a column, or a cell with values like :
F001
F002
F003
F004
F017
F020
F021
F121
F122
F123
...
I need a text result in a cell or in a message box to arrange this data into consecutive values, something like this:
"F001 to F004,F017, F020 to F021, F121 to F123 ..."
This text will be then used in other software by paste.
Hope you understand what Im asking.
Thank you very much!
I am new to Excel VBA, I work as an engineer and use a lot of data in Excel.
I wish I could simplify some of the work by opening this thread.
This may be very simple, but I can't seem to find a way.
Given a column, or a cell with values like :
F001
F002
F003
F004
F017
F020
F021
F121
F122
F123
...
I need a text result in a cell or in a message box to arrange this data into consecutive values, something like this:
"F001 to F004,F017, F020 to F021, F121 to F123 ..."
This text will be then used in other software by paste.
Hope you understand what Im asking.
Thank you very much!