Good Morning:
I am looking to create a macro to divide a cell (delimit) via a macro versus manually. The file comes in with a cell containing approx. 380 characters. I need to create a column for every 7 characters within that cell and whatever remains after the 371st character would populate the last cell of that row. In addition, the macro should loop until the cell is completely spit up by 7's then continue to the next row until a blank row is encountered. Any ideas (or examples) to get me started?
This is the first message I have ever sent for help, so am not sure of the procedure. Any assistance would be appreciated. Thanks; have a good day.
I am looking to create a macro to divide a cell (delimit) via a macro versus manually. The file comes in with a cell containing approx. 380 characters. I need to create a column for every 7 characters within that cell and whatever remains after the 371st character would populate the last cell of that row. In addition, the macro should loop until the cell is completely spit up by 7's then continue to the next row until a blank row is encountered. Any ideas (or examples) to get me started?
This is the first message I have ever sent for help, so am not sure of the procedure. Any assistance would be appreciated. Thanks; have a good day.