How do I convert a list to an Excel file?

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

Guest

I have a WORD file with 48 lines of comma delimited data in the form:

xxx,xxxxxxx,xxxxxx,x,x,xxx,xxxxxxxxx
xx,xxx,xxx,xxx,xxx,xx,x

I would like to convert the WORD list to EXCEL.

When I attempt to open the WORD file in EXCEL, I thought a conversion window
would appear....what I actually get is "incorrect format"
 
Hi!

Save the WORD file as a plain text file.

Then, when you open the file in Excel a Wizard will open
and step you through it. Just select COMMA as the
delimiter.

Biff
 
Select the data, including the paragraph returns at the end of each line.
(Turn your show/hide button on so you can see the returns.) Do not select
any additional returns that may reside BELOW the last line of data.

Go to the Table menu, and choose Convert text to table. Choose comma as the
delimiter and 7 columns. Hit OK. You should have a table. If it's not
selected (I forget), hit Table-Select table. Copy, go to Excel, paste.
Immediately hit Format-Cells, Alignment tab and untick "wrap text", Ok. Hit
Format-Column, Autofit.

****************
Anne Troy
www.piersontech.com
www.mrexcel.com
 
Back
Top