Highlight the range you want to convert...

Then select your macro recorder to record your Text to Column convert...

Then when you need it again, select the affected range and use your play
macro to do it automatically.

Note: You could always use the CTL-SHIFT-DOWN ARROW to select the affected
range if the data is all contiguous.