TB's Code Library

If it ain't tight, it ain't right!

Search

Thursday, June 25, 2015

Excel Formula to extract text between Parenthesis (Extract This Text)


=MID(A2,FIND("(",A2)+1,FIND(")",A2)-FIND("(",A2)-1)
Posted by zxkuqyb at 2:51 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Post Older Post Home

It's all about the code...

Code Archive

  • ►  2021 (1)
    • ►  April (1)
  • ▼  2015 (3)
    • ▼  June (3)
      • Excel Formula to extract text between Parenthesis ...
      • Excel - Trim Trailing Text
      • Trim the last character in an Excel cell
  • ►  2014 (1)
    • ►  March (1)
  • ►  2013 (5)
    • ►  October (2)
    • ►  August (2)
    • ►  May (1)
  • ►  2012 (6)
    • ►  September (1)
    • ►  March (4)
    • ►  February (1)
  • ►  2011 (2)
    • ►  November (1)
    • ►  April (1)
  • ►  2010 (3)
    • ►  November (1)
    • ►  October (1)
    • ►  March (1)
  • ►  2008 (3)
    • ►  October (1)
    • ►  March (2)
  • ►  2007 (2)
    • ►  October (1)
    • ►  August (1)
  • ►  2006 (2)
    • ►  April (1)
    • ►  March (1)
  • ►  2005 (22)
    • ►  December (1)
    • ►  October (1)
    • ►  August (3)
    • ►  July (2)
    • ►  June (6)
    • ►  May (9)

Helpful Links

  • Beyond the [Defaults]
  • Infopath Developer Community
  • Mr. Excel

Did you find a solution here?

Subscribe

Posts
Atom
Posts
Comments
Atom
Comments
Awesome Inc. theme. Powered by Blogger.