+ Reply to Thread
Results 1 to 3 of 3

Split text , uniformly paste in rows and columns.

  1. #1
    Registered User
    Join Date
    02-15-2006
    Posts
    14

    Question Split text , uniformly paste in rows and columns.

    HI

    I have the text in the notepad imported from a file.

    DATE FINAL DATE NAME AMT1 AMT2 VALUE

    3/31/2003 6/02/2003 THOMAS 4.950 15.00 693.00
    3/31/2003 6/02/2003 HARI 7.220 15.00 693.00
    3/31/2003 6/02/2003 THOMAS 4.950 15.00 693.00

    and so on...

    Now from the notepad , i had pasted in the excel column A.
    this shows the record in column A.

    how can i write a macro to paste the fields each on a column.

    PLEASE HELP

  2. #2
    Tom Ogilvy
    Guest

    Re: Split text , uniformly paste in rows and columns.

    You don't need to. Just do Data=>Text to Columns and walk through the
    wizard.

    An alternative would be to just open the file by using file=>Open which
    should walk you through the same wizard as above.
    --
    Regards,
    Tom Ogilvy


    "nshanmugaraj" <[email protected]>
    wrote in message
    news:[email protected]...
    >
    > HI
    >
    > I have the text in the notepad imported from a file.
    >
    > DATE FINAL DATE NAME AMT1 AMT2 VALUE
    >
    > 3/31/2003 6/02/2003 THOMAS 4.950 15.00 693.00
    > 3/31/2003 6/02/2003 HARI 7.220 15.00 693.00
    > 3/31/2003 6/02/2003 THOMAS 4.950 15.00 693.00
    >
    > and so on...
    >
    > Now from the notepad , i had pasted in the excel column A.
    > this shows the record in column A.
    >
    > how can i write a macro to paste the fields each on a column.
    >
    > PLEASE HELP
    >
    >
    > --
    > nshanmugaraj
    > ------------------------------------------------------------------------
    > nshanmugaraj's Profile:

    http://www.excelforum.com/member.php...o&userid=31570
    > View this thread: http://www.excelforum.com/showthread...hreadid=517835
    >




  3. #3
    Registered User
    Join Date
    02-15-2006
    Posts
    14

    need macro to open

    dear Tom Ogilvy,
    Thanks for the reply.

    but .. I need to open the notepad and do the split by writng an macro..
    PLS REPLY

+ 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