Hi All,
I've been trying to convert a large dataset from Text to Columns using VBA.
The data starts in column A is similar to the format below:
My actual data will have around 28 columns, and will have over 50,000 rows (though this can differ daily).
I wanted to make it dynamic as the number of rows I get each day may differ but wasn't sure how, so instead I just used the code:
This code worked yesterday but now my macro is skipping over the line of code without executing it. There is no error.
Is there a simpler way to dynamically convert an entire spreadsheet from Text to Column that's in the above formatted as the data below?
Thanks.
I've been trying to convert a large dataset from Text to Columns using VBA.
The data starts in column A is similar to the format below:
name~address~city~occupation~salary |
john~10 downing street~london~dentist~90000 |
My actual data will have around 28 columns, and will have over 50,000 rows (though this can differ daily).
I wanted to make it dynamic as the number of rows I get each day may differ but wasn't sure how, so instead I just used the code:
VBA Code:
Range("A1:A1048576").TextToColumns
This code worked yesterday but now my macro is skipping over the line of code without executing it. There is no error.
Is there a simpler way to dynamically convert an entire spreadsheet from Text to Column that's in the above formatted as the data below?
Thanks.