Text to Columns Question

M

Mark W.

I am very familiar with using the Text to Columns feature but for some reason
every excel file i open or if I import a text file to an excel sheet, excel
is automatically texting to columns using "space" as a delimiter. How can i
make Excel stop auto formating these sheets when i open them?
 
G

Gord Dibben

That's Excel trying to be helpful.

Rather than importing the text file can you open it directly in Excel?

Then the Text to Columns Wizard will run and allow you to choose.



Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible text-to-columns bug 3
Text to Columns Error 1
Text to columns 2
How do I turn off Text to Columns 2
Turn off text to columns 10
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Text-to-columns, but only 1st 2 & last delimiters 5
Text to Columns Question 3

Top