| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns Question
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text to Columns Question
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 On Mon, 14 Apr 2008 15:19:00 -0700, Mark W. <Mark wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text to Columns Question | Excel Discussion (Misc queries) | |||
| Text to columns question | Excel Worksheet Functions | |||
| Question about Data-Text to Columns command | Excel Discussion (Misc queries) | |||
| Text to Columns Question | Excel Worksheet Functions | |||
| Linking text columns with text and data columns | Excel Worksheet Functions | |||
Hybrid Mode
