Thread: Matching Text with With Certain Criteria
View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default Using Trim Function with Matching Text with With Certain Criteria
we could put in H2: =MID(G2,xInstrRev(G2,"NYSE:"),99)

xInstrRev(G2,"NYSE:")
will return the "rightmost" location of the substring: "NYSE:"
within G2, via searching right-to-left instead of left-to-right

Here's the googled post by Myrna:
http://tinyurl.com/zb97v
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Reply With QuoteReply With Quote