» 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:
- Special Edition Using Microsoft Access 2002
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
No comments have been submitted.
