+ Reply to Thread
Results 1 to 3 of 3

Substring-esque function

  1. #1
    Registered User
    Join Date
    06-29-2005
    Posts
    46

    Substring-esque function

    Hi, I am trying to create a function that, when given a string, can return a substring from this string. The strings I will be passing to the function are formatted as following: "text to return Procedure extra garbage." Basically, the only word that I know will be in there for sure is Procedure, and I want to return everything before that, regardless of what's after it. Is this possible, and if so, how? Thanks in advance for your help and I apologize if this is a dumb question.

    -Raman

  2. #2
    Jim Thomlinson
    Guest

    RE: Substring-esque function

    =LEFT( A1, SEARCH("Procedure", A1)-1)

    Where your target string is in cell A1
    --
    HTH...

    Jim Thomlinson


    "Raman325" wrote:

    >
    > Hi, I am trying to create a function that, when given a string, can
    > return a substring from this string. The strings I will be passing to
    > the function are formatted as following: "text to return Procedure
    > extra garbage." Basically, the only word that I know will be in there
    > for sure is Procedure, and I want to return everything before that,
    > regardless of what's after it. Is this possible, and if so, how? Thanks
    > in advance for your help and I apologize if this is a dumb question.
    >
    > -Raman
    >
    >
    > --
    > Raman325
    > ------------------------------------------------------------------------
    > Raman325's Profile: http://www.excelforum.com/member.php...o&userid=24748
    > View this thread: http://www.excelforum.com/showthread...hreadid=521157
    >
    >


  3. #3
    Registered User
    Join Date
    06-29-2005
    Posts
    46
    Great, thanks a lot!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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