+ Reply to Thread
Results 1 to 2 of 2

Extract data from Excel to a txt file

  1. #1
    Registered User
    Join Date
    05-02-2005
    Posts
    1

    Question Extract data from Excel to a txt file

    Hi , I have a Worksheet with a form. I'm trying to generate a text file from a cell wich contains a simple chain of text values. How can I extract that chain and create a TXT file from that cell?

  2. #2
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256
    If you transfer all values to a separate sheet: Sheet 2
    Column A....Column B....Column C...
    =A3.............=B3..............=F10
    =A4.............=B4..............=F11
    ....

    You can then select menu:Edit>Save As>and selects Save as type:Text(tab delimited)*.txt .... there are several different *.txt types, so you probably have to test which works the best - I haven't no experience from the different types.

    Hope it helps

    Ola Sandström

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1