Results 1 to 8 of 8

Seperate date by symbol?

Threaded View

  1. #1
    Registered User
    Join Date
    07-28-2005
    Posts
    34

    Seperate date by symbol?

    Hi

    I'm trying to figure out a formula that will seperate by symbol, specificlly "/"
    ----------------------
    IE
    Original cell data

    Rear Sprocket/Urban Industries/ (Bolt Cirlce-6 Bolt;Bolt Hole Diameter-;Hub ID-)

    Resulting cell data

    Rear Sprocket/Urban Industries

    ----------------------
    I want it to keep the words "Rear Sprocket" / and the following company name while disguarding everythign else including the second "/"

    I may be a bit confusing i'm sorry please take a look at my sample file

    Thanks again!
    Attached Files Attached Files

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