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)
 
You must log in or register to reply here.

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Text Import Wizard 2
Text Import wizard 2
Importing text files automaticly. 5
Import wizard does not display 1
Open Text Files in Excel, Changed Behavior 4
Text Files 1
Access Subscript out of range when importing into access 2010 from excel 0

Back
Top