I need a VBA Code that can extract data from column A between brackets () like the below example :
I have these data on column A1 and when run VBA code must give me the below result :
VP,ST,VCAD,X27,(PC3601),PC3601,PC3601_0_1,(TR),(VP),(PS3601)
Result must be in column B1
(PC3601),(TR),(VP),(PS3601)