+ Reply to Thread
Results 1 to 6 of 6

Pulling specific text within a text in which the information is typed differently

  1. 08-02-2014, 03:44 PM #1
    djmatok
    djmatok is offline
    Forum Contributor
    Join Date
    06-27-2012
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    164

    Pulling specific text within a text in which the information is typed differently

    I am trying to pull titles out of a text string but its quite difficult because of how the data was originally inputted. I need titles that appear in the following different formats

    " title"
    title/
    title"
    These titles were not inputted consistently and it could show up in the middle or at the beginning. I have attached a sample of the data that i am working with and a sample formula that i was trying to use to obtain my information. The formula that i have is a nested formula of find and mid formula that searches for the text within " ". Please help.

    thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-02-2014, 04:29 PM #2
    popipipo
    popipipo is offline
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,293

    Re: Pulling specific text within a text in which the information is typed differently

    I don't think you will manage it with one formula.

    First delete all the doubles (almost 50%)

    Then use this formula:
    =LEFT(MID(A2;FIND("""";A2)+1;100);FIND("""";MID(A2;FIND("""";A2)+1;100))-1)
    This formula gives for 65% a result.
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong
    Reply With QuoteRegister To Reply
  3. 08-02-2014, 04:51 PM #3
    djmatok
    djmatok is offline
    Forum Contributor
    Join Date
    06-27-2012
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    164

    Re: Pulling specific text within a text in which the information is typed differently

    thank you Holland ! but for all the other titles that start at the beginning how can i pull the text in front of "/"? and all the other variations
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 08-02-2014, 05:01 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Pulling specific text within a text in which the information is typed differently

    Have you tried text2Columns?

    1st make a copy of your data off a few columns to the right(in case it messes up, then you still have your data)

    Then highlight all your (copied) data, select T2C/delimited/OK/in Other, enter "


    That will probably get youi a long way along, but you may have to repeat the process for the other delimiters
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  5. 08-02-2014, 05:29 PM #5
    vogel997
    vogel997 is offline
    Registered User
    Join Date
    02-09-2014
    Location
    New York
    MS-Off Ver
    Excel 2013
    Posts
    84

    Re: Pulling specific text within a text in which the information is typed differently

    Titels1.xlsx

    This works for almost all...
    Reply With QuoteRegister To Reply
  6. 08-02-2014, 06:11 PM #6
    djmatok
    djmatok is offline
    Forum Contributor
    Join Date
    06-27-2012
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    164

    Re: Pulling specific text within a text in which the information is typed differently

    thnk you Vogel and holland this definitely worked
    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)

Similar Threads

  1. Pulling Out specific Text
    By Hollow55 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-04-2013, 04:56 AM
  2. [SOLVED] Pulling specific text string from a cell
    By smtwidle in forum Excel General
    Replies: 6
    Last Post: 06-25-2012, 03:28 PM
  3. [SOLVED] Excel 2007 : Compare text returned as result of formula in A1 with text typed in B1 to see if match
    By tsedek in forum Excel General
    Replies: 6
    Last Post: 06-08-2012, 06:54 PM
  4. Pulling specific parts out of text in a cell.
    By Befuddled in forum Excel General
    Replies: 3
    Last Post: 06-12-2010, 01:51 AM
  5. pulling specific text from a notepad document
    By smoosh1011 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-06-2009, 05:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1