Text import Wizard

  • Thread starter Thread starter Vicki
  • Start date Start date
V

Vicki

Hi Guys

Can someone help?

I have an excel spreadsheet that when originally opened
automatically activated the Convert Text to Columns
Wizard. But now when opened it doesn't activate the Text
Wizard even though the text is still in one column.

Is it because Excel senses that the spreadsheet has
already been through the conversion?

Is there a way I can get Excel to automatically start this
wizard when I open my spreadsheet.

I look forward to hearing from you.

Thank U
 
1. To activate the Convert Text-to-Col wizard manually:

a. select the column
b. click Data > Text to Columns

2. To have the wizard auto-start,
(but is this necessary, given step 1 above?)

Save the file as either
(click File > Save As
and select under "Save as type"):

Formatted Text (Space delimited)

or as

Text (Tab delimited)
 
Back
Top