Hi all..
So my problem is as follows and not sure if it can be done...
In Column B and starting in B2. I have descending data in format of 1-2-3
I need a macro to remove the hyphen, then copy 1 to C2, 2 to D2 and 3 to E2
This needs to be repeated down entire B column and on different sheets the data extends to different lengths but max 26 rows.
Hope thats understandable and Any help would be greatly appreciated..
So my problem is as follows and not sure if it can be done...
In Column B and starting in B2. I have descending data in format of 1-2-3
I need a macro to remove the hyphen, then copy 1 to C2, 2 to D2 and 3 to E2
This needs to be repeated down entire B column and on different sheets the data extends to different lengths but max 26 rows.
Hope thats understandable and Any help would be greatly appreciated..