# Text

| Function | Description                                                                                                                                                                                                                                                            |
| -------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| LOWER    | <p>Converts all characters in a supplied text string to lower case </p><p> <code>example: =LOWER("Hello")</code> </p><p><code>result: hello</code></p>                                                                                                                 |
| UPPER    | <p>Converts all characters in a supplied text string to upper case</p><p><code>example: =UPPER("Hello")</code> </p><p><code>result: HELLO</code></p>                                                                                                                   |
| TRIM     | <p>Removes duplicate spaces, and spaces at the start and end of a text string</p><p><code>example: =UPPER("   Hello World    !")</code> </p><p><code>result: Hello World !</code></p>                                                                                  |
| LEFT     | <p>Returns a specified number of characters from the start of a supplied text string. example<code>: =LEFT("Hello",2)</code> </p><p><code>result: He</code></p>                                                                                                        |
| MID      | <p>Returns a specified number of characters from the middle of a supplied text string <code>syntax:=MID(text,start\_index</code><em><code>,no\_chars)</code></em></p><p><code>example =MID("Ajay Kumar K",6,5)</code> </p><p><code>result: Kumar</code></p>            |
| RIGHT    | <p>Returns a specified number of characters from the end of a supplied text string </p><p><code>example: =RIGHT("Hello",2)</code> </p><p><code>result: lo</code></p>                                                                                                   |
| FIND     | <p>Returns the position of a supplied character or text string from within a supplied text string (case-sensitive). </p><p><code>syntax:=FIND(text,find\_text,startPoistion)</code> </p><p><code>example: =FIND("AJAY","A",1)</code> </p><p><code>result: 1</code></p> |
| LEN      | <p>Returns the length of a supplied text string </p><p><code>example: =LEN("Hello")</code> </p><p><code>result: 5</code></p>                                                                                                                                           |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.qatts.com/functions/text.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.