+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Extract Data from Word/text

  1. 12-08-2011, 12:52 PM #1
    maverick09
    maverick09 is offline
    Registered User
    Join Date
    03-04-2011
    Location
    ind
    MS-Off Ver
    Excel 2003
    Posts
    19

    Extract Data from Word/text

    please find attached sheet. I have written my query in excel sheet itself


    Please Help



    Dear
    Excelforum users..
    I am very thankful to this forum for solving my problems and helping me in my work.


    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-08-2011, 12:57 PM #2
    JieJenn
    JieJenn is offline
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Extract Data from Word/text

    In cell C4, enter =IF(ISERROR(SEARCH("Yes",B4)),"",B4) and drag it down
    Learn Data Analysis or Excel youtube.com/jiejenn
    Reply With QuoteRegister To Reply
  3. 12-08-2011, 01:00 PM #3
    maverick09
    maverick09 is offline
    Registered User
    Join Date
    03-04-2011
    Location
    ind
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Extract Data from Word/text

    Quote Originally Posted by JieJenn View Post
    In cell C4, enter =IF(ISERROR(SEARCH("Yes",B4)),"",B4) and drag it down
    Wow!Thank you so much
    I got reply in just 2 min,
    I am new to Excel and I am searching solution for this for last 2 days...

    Thanks for helping me
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1