Results 1 to 12 of 12

Extract Multi-line Data Based on prefix

Threaded View

  1. #1
    Registered User
    Join Date
    12-02-2011
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    73

    Extract Multi-line Data Based on prefix

    Hi I have a cell which is multi-line i need to get text after specific prefix

    Primary Examiner: STNFORD, CHRITOPHER J

    i only wish to extract BOLD text from entire cell. this prefix can be repeated many time then output need to be stacked in same cell.
    attached is the sample file with desired VBA output.

    can anyone help with VBA
    regards
    Monika
    Attached Files Attached Files
    Last edited by chilli16; 05-29-2018 at 04:52 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Extract Multi-line Data Based on Form input
    By chilli16 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-30-2018, 12:07 PM
  2. [SOLVED] Extract Multi-line data and date comparison
    By chilli16 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-23-2018, 12:23 PM
  3. VBA Automatically concatenate cell data based on data, and prefix with specific word.
    By jamieswift1977 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-30-2017, 02:16 PM
  4. Extract Numbers and prefix letter
    By aromaveda in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-22-2009, 09:00 PM
  5. Migrate multi line data from one sheet to another
    By softspoke in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-27-2008, 05:23 PM
  6. Parsing cell data with multi-line cells
    By nbn22385 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-06-2007, 05:35 AM
  7. Replies: 3
    Last Post: 06-07-2005, 09:05 AM

Tags for this Thread

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