Help changing text to columns

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

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.