Results 1 to 23 of 23

extract a string from variable text

Threaded View

  1. #9
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: extract a string from variable text

    My final master piece FILTERXML()

    Formula: copy to clipboard
    =FILTERXML("<F><d>"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"_"," "),"-"," "),")"," ")," ","</d><d>")&"</d></F>","//d[translate(.,'1234567890','')!=. and string-length()>3 and not(starts-with(., 'P'))][1]")
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] extract text form text string( extract 5 charactors in front of all left parenthese)
    By happyexcel2021 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-30-2021, 06:05 PM
  2. [SOLVED] Extract string from variable length string
    By JeffGrant in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-30-2021, 03:47 AM
  3. [SOLVED] Extract a variable length number from within a text string
    By Kirk3737 in forum Excel General
    Replies: 2
    Last Post: 10-27-2020, 02:27 PM
  4. [SOLVED] How to extract a piece of a string variable, and assign to a new variable
    By jmccoughlin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2015, 11:50 PM
  5. [SOLVED] Extract data from variable text string into seperate columns
    By kinnywayne in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-29-2014, 04:43 PM
  6. Extract Variable Length Text String
    By sshot1 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-12-2012, 06:21 PM
  7. [SOLVED] EXTRACT TEXT FROM TEXT STRING:The names are of variable length
    By carricka in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-08-2005, 06:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1