Results 1 to 7 of 7

Return string between two specific characters

Threaded View

  1. #1
    Registered User
    Join Date
    05-02-2006
    Posts
    7

    Return string between two specific characters

    What is the best formula to return a string between two specific characters?

    Ex:
    Aasd asd asdf PO#123456 adf asdf asdf
    Aasdf asdf adsf PO# 123457 adsf asdf asd $100.00
    Asdf asf #123-123458-0C asdf
    Asdf #123459
    Asdf asdf asdf adsf # 123455-12 $5.00

    I want to extract 12345X from each cell.
    Sometimes there is a space between the number and #.
    Sometimes the number ends at the end of the cell.
    Sometimes the number has -'s
    So, if there is a hypen at the end of the string followed by only two characters, I want the number to end before the hyphen if there are more, i want the whole strig after the hyphen.
    Last edited by kaytoo; 12-14-2006 at 08:57 AM. Reason: wanted email notification

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