|  

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

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


    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
    Name
    Comment Title
    Comments