title: How to specify all columns as "Text" in Text to Columns function in Data tab?
body: <p>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.</p>
  
  <p>This is a problem to do manually because I would have to go through every column and click Text, and the wizard doesn't even show all the columns unless you scroll. Ideas?</p>