Text Functions

These functions are used for entering, searching, replacing and manipulating text strings

  • Family: PQL
  • Library: Spreadsheet
  • This function can be used with the Solve plug-in
  • Function List

    ASC

    BAHTTEXT

    CHAR

    CLEAN

    CODE

    CONCAT

    CONCATENATE

    DBCS

    DOLLAR

    EXACT

    FIND

    FIXED

    LEFT

    LEN

    LOWER

    MID

    OBJECT

    PROPER

    REPLACE

    REPT

    RIGHT

    SEARCH

    SEARCHB

    SUBSTITUTE

    T

    TEXT

    TEXTAFTER

    TEXTBEFORE

    TEXTJOIN

    TEXTSPLIT

    TRIM

    UNICHAR

    UNICODE

    UPPER

    VALUE