0
Undo
Votes
Hi guys,
I have read through the forum and I have found a manual solution for my project.
But what I want to do now, is create a VBA macro, using KUTOOLS features, to automate it.
A sample original row of data looks like this below
At the moment, I use the 'Text to Columns' feature, with Delimited selected, then Semicolon and Other (x) to split the data.
New data looks like below
I then go to 'Find' and replace (*) with blank to remove the words within the parenthesis.
Could someone help me create a way to automate this entire process with a single macro?
Thanks in advance.
I have read through the forum and I have found a manual solution for my project.
But what I want to do now, is create a VBA macro, using KUTOOLS features, to automate it.
A sample original row of data looks like this below
1 x Primsal 7w B22WWB (outdoor);3 x Ecobulb 12w Outdoor Reflector (outdoor);2 x Primsal 7w E27WWB (outdoor);3 x Ecobulb 8w Indoor Reflector (allbr);2 x Ecomatters E14 Candle (allbr);6 x Primsal 7w E27WWB (lounge);5 x Primsal 7w B22WWB (lounge);4 x Primsal 7w B22WWB (allbr);3 x Primsal 7w E27WWB (allbr);2 x Ecobulb 8w Indoor Reflector (lounge);1 x Primsal 7w B22WWB (laundry); |
At the moment, I use the 'Text to Columns' feature, with Delimited selected, then Semicolon and Other (x) to split the data.
New data looks like below
1 | Primsal 7w B22WWB (outdoor) | 3 | Ecobulb 12w Outdoor Reflector (outdoor) | 2 | Primsal 7w E27WWB (outdoor) | 3 | Ecobulb 8w Indoor Reflector (allbr) | 2 | Ecomatters E14 Candle (allbr) | 6 | Primsal 7w E27WWB (lounge) | 5 | Primsal 7w B22WWB (lounge) | 4 | Primsal 7w B22WWB (allbr) | 3 | Primsal 7w E27WWB (allbr) | 2 | Ecobulb 8w Indoor Reflector (lounge) | 1 | Primsal 7w B22WWB (laundry) |
I then go to 'Find' and replace (*) with blank to remove the words within the parenthesis.
Could someone help me create a way to automate this entire process with a single macro?
Thanks in advance.
There are no replies made for this post yet.