TB's Code Library

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

Search

Friday, August 03, 2007

In Excel, code to grab the text to the right of any specific character

=TRIM(RIGHT(A1,LEN(A1)-SEARCH("(",A1)))
Posted by zxkuqyb at 5:09 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Excel
Newer Post Older Post Home

It's all about the code...

Code Archive

  • ►  2021 (1)
    • ►  April (1)
  • ►  2015 (3)
    • ►  June (3)
  • ►  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)
      • In Excel, code to grab the text to the right of an...
  • ►  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.