» 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:
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Special Edition Using Microsoft Outlook 2002
- Investing for Dummies, Third Edition
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
the cell contains 1170500
How can I format it to look like a coordinate 117:05:00