+ Reply to Thread
Results 1 to 4 of 4

Need help with text parsing formula

  1. 08-19-2016, 04:59 PM #1
    SEMMatt
    SEMMatt is offline
    Forum Contributor
    Join Date
    01-14-2011
    Location
    New York City, USA
    MS-Off Ver
    Excel 2010
    Posts
    194

    Need help with text parsing formula

    Hi, can anyone help me with a formula to extract the string 'wx374oP' from this URL using Excel:

    www.mydomain.com/?site=wx374oP&source=test

    That string will always sit between ?site= and &source=

    Thank you,
    Reply With QuoteRegister To Reply
  2. 08-19-2016, 05:03 PM #2
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Need help with text parsing formula

    Like this...

    =MID(A1,FIND("=",A1)+1,FIND("&",A1)-1-FIND("=",A1))
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  3. 08-19-2016, 05:08 PM #3
    SEMMatt
    SEMMatt is offline
    Forum Contributor
    Join Date
    01-14-2011
    Location
    New York City, USA
    MS-Off Ver
    Excel 2010
    Posts
    194

    Re: Need help with text parsing formula

    @TonyValko thanks for that and the quick reply!
    Reply With QuoteRegister To Reply
  4. 08-19-2016, 05:19 PM #4
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Need help with text parsing formula

    You're welcome!
    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. Parsing text
    By rwl518p in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-06-2014, 07:20 AM
  2. Parsing out Text from a Cell that Contains Multiple Text Values
    By bcolon in forum Excel General
    Replies: 1
    Last Post: 09-25-2013, 12:18 PM
  3. [SOLVED] Parsing Text
    By wpwalsh in forum Excel General
    Replies: 4
    Last Post: 08-09-2012, 05:17 PM
  4. Parsing text with VBA
    By Carnifex930 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-13-2010, 06:28 PM
  5. text parsing
    By captedgar in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-22-2010, 09:21 PM
  6. Parsing Text ( Last Name, First Name )
    By scotfitz in forum Excel General
    Replies: 2
    Last Post: 01-05-2009, 09:29 PM
  7. Text Parsing??
    By amsnss in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-12-2007, 03:43 PM
  8. Parsing out text
    By halfordryan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2007, 04:37 AM

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