how do i up load an ascii file to excel to do labels in words

G

Guest

did help up loading a file from ascii text to excel, to do labels in words,
please help...
 
M

macropod

File|Open and choose either 'All files (*.*)' or the appropriate file type
for your text file, then select your file from the list.

Cheers
 
G

Gord Dibben

Just browse to the *.txt file and open it.

When you have it opened in Excel, massage the data to the appropriate formatting
then save as an Excel workbook.

For help on Word mail merge using Excel or Access as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm


Gord Dibben MS Excel MVP


did help up loading a file from ascii text to excel, to do labels in words,
please help...
Click to expand...

Gord Dibben MS Excel MVP
 
E

Earl Kiosterud

Dotties,

If I understand you correctly, you want to get an ascii file into an excel
sheet to use as a data source for a label mail merge in Microsoft Word. If
the ascii file will open directly into Excel, then you can use the ascii
file as your data source for the labels. No need to put it into Excel.
 

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

Convert Excel file ti ASCII format to allow a SIFT transfer 1
Entering ASCII codes with Excel 2003 2
Merge data from an ascii file into a Word doc 1
Save Excel to ASCII format 2
How do I convert an Excel file to an ASCII file? 1
How do I convert excel file into ASCII text file with alignment? 2
How do I print mailing labels from an Excel file? 5
CSV to ASCII 4

Top