arranging import text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I'm trying to import a .txt file and I'm using the import wizard. I
clicked the fixed width option. On the next step you set the column breaks
and I'm confused on how to set breaks. For example, on the first line it has
last name, first name, address, but the city and state are on the second
line. how can I get each contact information on one row? Mindy
 
The text import wizard assumes that each record is on one line of
the text files; it doesn't support multiple line records. You'll
have to write an import procedure yourself.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
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

how do I remove line breaks from several cells? 6
import 2
Importing text-files 6
text import into excel 2000 5
Convert address block into delimited rows? 1
Importing text into Excel... 3
Importing Large Text Files 1
change row to column 1

Back
Top