如何在“数据”选项卡的“文本到列”功能中将所有列指定为“文本”？

I have data in a column that needs to be split into multiple columns using Text to Columns in the Data tab. However, there will be a variable amount of columns created for each row, variable from 1 - 1000. In the Text to Columns wizard Step 3, it defaults to 'General' format for all columns. My data involves very big numbers, and I do not want them trailed (rounded), so I need to set the format as Text.I have data in a column that needs to be split