Excel Tip: Parsing text to the right of a search criteria - delimiter in Microsoft Excel / Microsoft Excel Tips / ExcelTip.com

Tip Printed from ExcelTip.com

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