text to columns on multiple columns

hello,

so I have a spreadsheet with approx. 600 columns and 38 rows. in every other column, I have a cell that needs text to columns with ( as the delimiter. I've tried to create a macro with the recording tool where I add in two blank columns and do text to columns on that section. but I dont want to have to perform this macro on every single section, as I'll be doing it about 300 times. Is there any way around this?

For reference, getting the top format from the bottom one, but for about 300 columns at the same time. Thank you so much for any help!