Results 1 to 7 of 7

Thread: Nested Search Function Excel Formula

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 10-28-2012, 02:05 PM #3
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi

    Couple more ways ..

    =REPLACE(SUBSTITUTE(A2,"AcrobatFamily","AcrobatPro "),1,SEARCH("AcrobatPro",SUBSTITUTE(A2,"AcrobatFam ily","AcrobatPro"))+10,"")

    =TRIM(MID(SUBSTITUTE(SUBSTITUTE(A2,"AcrobatFamily_ ","AcrobatPro_"),"AcrobatPro_",REPT(" ",200)),200,255))

    Edit: there is no space between the characters of Family or after AcrobatPro
    Last edited by Admin; 10-28-2012 at 05:09 PM.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Use Native Excel Function Lookup Formula In VBA
    By ramananhrm in forum Excel Help
    Replies: 8
    Last Post: 05-03-2013, 09:10 AM
  2. Nested If Formula With Multiple Conditions
    By lprc in forum Excel Help
    Replies: 10
    Last Post: 04-22-2013, 07:27 PM
  3. Excel Nested IF Function With 3 Conditions
    By patsir in forum Excel Help
    Replies: 3
    Last Post: 08-25-2012, 07:15 PM
  4. VBA Function to Search in Array
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 04-10-2012, 11:34 AM
  5. Excel Nested IF 3 Condition Formula
    By yomgi in forum Excel Help
    Replies: 2
    Last Post: 02-20-2012, 11:50 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