+ Reply to Thread
Results 1 to 2 of 2

Extract text between two words in a text file and paste to Excel

  1. #1
    Registered User
    Join Date
    09-15-2016
    Location
    fghhjj
    MS-Off Ver
    2016
    Posts
    1

    Extract text between two words in a text file and paste to Excel

    hello

    I have a large text file. I need an excel macro code, that work :

    1: open text file

    2: find and extract text between Two world , like between "start" and "end"


    3: copy this text
    4: close text file
    5: paste on excel cell

    tanks

    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. I have updated it for you this time because you are a new member. --6StringJazzer
    Last edited by 6StringJazzer; 10-06-2018 at 02:42 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019; O365
    Posts
    19,141

    Re: Extract text between two words in a text file and paste to Excel

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extract specific columns from text file and export to another text file
    By KingTamo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-02-2017, 01:00 AM
  2. [SOLVED] Export specific range to text file and import the text file if needed
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-06-2015, 07:38 AM
  3. Replies: 2
    Last Post: 08-16-2013, 02:45 AM
  4. Replies: 1
    Last Post: 02-23-2013, 08:36 AM
  5. Copy Excel to Text file and pass Text file to Access Table
    By robbie_xcell in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-27-2011, 01:53 PM
  6. Importing a text file to an existing sheet, with a dialog to pick the text file
    By titushanke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2011, 01:43 PM
  7. looping, Open text file, copy text, close text file
    By jwilds1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2009, 05:12 PM

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