Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default how do i up load an ascii file to excel to do labels in words

did help up loading a file from ascii text to excel, to do labels in words,
please help...
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 329
Default how do i up load an ascii file to excel to do labels in words

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

Cheers

--
macropod
[MVP - Microsoft Word]


"dotties" wrote in message
...
did help up loading a file from ascii text to excel, to do labels in

words,
please help...



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default how do i up load an ascii file to excel to do labels in words

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/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben MS Excel MVP


On Wed, 1 Nov 2006 21:15:02 -0800, dotties
wrote:

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


Gord Dibben MS Excel MVP
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 611
Default how do i up load an ascii file to excel to do labels in words

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.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"dotties" wrote in message
...
did help up loading a file from ascii text to excel, to do labels in
words,
please help...



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export Excel File to Ascii rlnicholsms Excel Discussion (Misc queries) 1 June 7th 06 05:04 PM
Weird File Open/Save As Behavior [email protected] Excel Discussion (Misc queries) 0 December 9th 05 02:26 AM
How do I use info from an excel program and make file labels? Label maker Setting up and Configuration of Excel 1 November 30th 05 03:46 PM
Opening an Excel file Sheldon Zaklow Excel Discussion (Misc queries) 0 March 3rd 05 10:29 PM
how can I print address labels from an excel file bcowan Excel Discussion (Misc queries) 2 February 10th 05 02:07 PM


All times are GMT +1. The time now is 01:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"