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