Extract information from cell

Posted on 2012-09-13
Last Modified: 2012-09-13
I have a spreadsheet where column A will have numbers (example as follows):

I need to extract everything after the first "/". The characters after the "/" could be both numbers and alpha and of various length (4 - 20 length).

Thank you in advance.
Question by:squirrelzan
    LVL 23

    Accepted Solution


    LVL 43

    Assisted Solution

    by:Saqib Husain, Syed
    Another formula

    LVL 43

    Assisted Solution

    by:Saqib Husain, Syed
    If you simply want to get rid of the characters upto the / you can do

    Data > Text to columns > Delimited > / > select the first column > Select "Do not import"

    Author Closing Comment

    All three solutions worked perfectly. Thank you.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Copy Value of cell in formula 1 25
    Surpressing messages VBA 9 32
    Check version 13 45
    Excel - text to column problem 2 17
    Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
    My experience with Windows 10 over a one year period and suggestions for smooth operation
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now