+ Reply to Thread
Results 1 to 3 of 3

.txt to excel

  1. #1
    Registered User
    Join Date
    07-11-2005
    Posts
    40

    .txt to excel

    I have a text file, tab delimited (i think)
    When i open this file in Excel all the "fields" are in one collumn.
    I would like each "field" in different collumns.

    Any sugestions?
    Thanks

  2. #2
    paul
    Guest

    RE: .txt to excel

    under the data menu go to text to columns..
    --
    paul
    [email protected]
    remove nospam for email addy!



    "pmarques" wrote:

    >
    > I have a text file, tab delimited (i think)
    > When i open this file in Excel all the "fields" are in one collumn.
    > I would like each "field" in different collumns.
    >
    > Any sugestions?
    > Thanks
    >
    >
    > --
    > pmarques
    > ------------------------------------------------------------------------
    > pmarques's Profile: http://www.excelforum.com/member.php...o&userid=25110
    > View this thread: http://www.excelforum.com/showthread...hreadid=550292
    >
    >


  3. #3
    Registered User
    Join Date
    07-11-2005
    Posts
    40
    Thanks thats it

+ 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