excel - How to specify all columns as "Text" in Text to Columns function in Data tab? -
i have data in column needs split multiple columns using text columns in data tab. however, there variable amount of columns created each row, variable 1 - 1000. in text columns wizard step 3, defaults 'general' format columns. data involves big numbers, , not want them trailed (rounded), need set format text. this problem manually because have go through every column , click text, , wizard doesn't show columns unless scroll. ideas? although not want (and see don't idea of scrolling), when presented data preview showing each column general. you can select first column header , holding shift key scroll right , select of columns @ once. then select text data format. not best, better selecting each individually.