Information Functions

-

  • EXACT

    Tests if two supplied text strings are exactly the same and if so, returns TRUE; Otherwise, returns FALSE. (case-sensitive)

  • FIND

    Returns the position of a supplied character or text string from within a supplied text string (case-sensitive)

  • LEN

    Returns the length of a supplied text string

  • SEARCH

    Returns the position of a supplied character or text string from within a supplied text string (non-case-sensitive)

  • T

    Tests whether a supplied value is text and if so, returns the supplied text; If not, returns an empty text string.

Excelq.com doing business as a Service of Venttraffic Media Inc. Excel and other words on this site may be trademarks or registered trademarks of Microsoft Corporation. Microsoft Corporation is not connected in any way with this website, and makes no endorsement of the site or its related contents. All rights reserved. Website powered by Venttraffic Media Inc.