|  

» Parsing text to the right of a search criteria - delimiter in Microsoft Excel

CATEGORY - Excel Text Formulas VERSION - All Microsoft Excel Versions

Enter the following text in cell A1: c:\ExcelTip (our search criteria - delimiter will be the "\")

Enter the following formula in cell A2: =IF(ISNUMBER(SEARCH("\",A1)),RIGHT(A1,LEN(A1)-SEARCH("\",A1)),A1)

  • The Result: ExcelTip

    • Screenshot // Parsing text to the right of a search criteria - delimiter in Microsoft Excel
    Parsing text to the right of a search criteria - delimiter in Microsoft Excel


    Book Store:

    VIEW ALL BOOKS

    Recommended Books:

    Print Tip
    Add to My Tips
    Rate This Tip
    12 34 5
    Rating: 4.49     Views: 25418
    How can i put colons in a text string
    tpalick
    I want to format a number to include colons to look like a coordinate value.
    the cell contains 1170500
    How can I format it to look like a coordinate 117:05:00
    Click here to post comment
    For Registered Users
    Click here to Regiser
    For Guest
    Name
    Comment Title
    Comments


    Terms and Conditions of use

    The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

    Copyright © 2003 ExcelTip.com Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation