» 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)
Book Store:
Recommended Books:
- Keys to Reading an Annual Report (Barron's Business Keys)
- Microsoft Outlook 2002 for Dummies
- Microsoft Excel 2002 Simply Visual
- Microsoft Excel Version 2002 Step by Step
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Financial Statement Analysis with S&P insert card
the cell contains 1170500
How can I format it to look like a coordinate 117:05:00