+ Reply to Thread
Results 1 to 3 of 3

Character Stripping

  1. #1

    Character Stripping

    Hi,

    I am trying to strip characters from a string upto a certain character
    for instance :

    CG016_30425 to become 30425
    Hamblemeads_39450 to become 39450

    Can anyone help ?

    Thanks Simon.


  2. #2
    Bob Phillips
    Guest

    Re: Character Stripping

    =RIGHT(A1,LEN(A1)-FIND("_",A1))

    --
    HTH

    Bob Phillips

    (remove xxx from email address if mailing direct)

    <[email protected]> wrote in message
    news:[email protected]...
    > Hi,
    >
    > I am trying to strip characters from a string upto a certain character
    > for instance :
    >
    > CG016_30425 to become 30425
    > Hamblemeads_39450 to become 39450
    >
    > Can anyone help ?
    >
    > Thanks Simon.
    >




  3. #3

    Re: Character Stripping

    Worked like a dream, thanks alot.


+ 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