+ Reply to Thread
Results 1 to 3 of 3

how to save as txt file in this format please

Hybrid View

  1. #1
    Registered User
    Join Date
    04-23-2012
    Location
    egypt
    MS-Off Ver
    Excel 2003
    Posts
    9

    Angry how to save as txt file in this format please

    hello please how to save this file aa.jpg
    as text file in this format
    2004.08.19,00:00,100.00,104.06,95.96,100.34,22351900,
    2004.08.20,00:00,101.01,109.08,100.50,108.31,11428600,
    2004.08.23,00:00,110.75,113.48,109.05,109.40,9137200,
    2004.08.24,00:00,111.24,111.60,103.57,104.87,7631300,
    2004.08.25,00:00,104.96,108.00,103.88,106.00,4598900,
    2004.08.26,00:00,104.95,107.95,104.66,107.91,3551000,

    thanks in advance

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525

    Re: how to save as txt file in this format please

    High light your range and goto Data=>text to columns
    check delimited then hit next
    check comma and finish


    Save the sheet as .csv format.
    open it in note to see it as it originally was.
    Last edited by davesexcel; 04-23-2012 at 04:36 AM.

  3. #3
    Registered User
    Join Date
    04-23-2012
    Location
    egypt
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: how to save as txt file in this format please

    thanks alot

+ 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