Hi ninja
My excel column as more than 1lakh rows,
1.I want to covert in to (add ; at end of value ) to generate reports in our application
A- column
-----------------
1097456607
2087765673
4678296689
Convert to ::
1097456607;2087765673;4678296689......
i can't concotinate more than 36k records,
2.i can run report max upto 999 records so I need to split 999record to each batch
please help in VBA macro, to simplify my process, thanks in advance
My excel column as more than 1lakh rows,
1.I want to covert in to (add ; at end of value ) to generate reports in our application
A- column
-----------------
1097456607
2087765673
4678296689
Convert to ::
1097456607;2087765673;4678296689......
i can't concotinate more than 36k records,
2.i can run report max upto 999 records so I need to split 999record to each batch
please help in VBA macro, to simplify my process, thanks in advance
Last edited: