|  

» Find if a character is in a cell in Microsoft Excel

CATEGORY - Excel Text Formulas VERSION - All Microsoft Excel Versions
Enter the following text in cell A1: Total ?
  • Search term is "?"

    • Enter the following formula in cell B2: =FIND("?",A1)>0

    The result: TRUE




    Book Store:

    VIEW ALL BOOKS

    Recommended Books:

    Print Tip
    Add to My Tips
    Rate This Tip
    12 34 5
    Rating: 2.70     Views: 83717
    No comments have been submitted.
    Name
    Comment Title
    Comments

    Excel Formula and Function

    Excel Date and Time

    Excel Macros and VBA

    Excel Text, Editing and Format

    Excel General

    Excel Data

    Excel 2007 Tutorials


    Terms and Conditions of use

    The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

    Copyright © 2003 ExcelTip.com Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation