---
title: "Text Functions"
url: "https://helpcentre.esayworkmobile.co.uk/en/article/text-functions"
language: "en"
last_updated: "2025-06-12T13:24:37.427Z"
---

# Text Functions

The following section describes each available function for manipulating text strings, its associated syntax and examples of how to use each.

### **LEN**

Returns you the length of a piece of text i.e. the number of characters. Note that spaces count.

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| LEN(*x*) | *x* is text | A number |

| **Example** | **Result** |
| --- | --- |
| \=LEN("Mobile Forms") | 12 |

* * *

### **UPPER**

Returns a string of text with all letters in upper-case.

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| UPPER(*x*) | *x* is text | Text |

| **Example** | **Result** |
| --- | --- |
| \=UPPER("Mobile Forms") | "MOBILE FORMS" |

* * *

### **LOWER**

Returns a string of text with all letters in lower-case.

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| LOWER(*x*) | *x* is text | Text |

| **Example** | **Result** |
| --- | --- |
| \=LOWER("Mobile Forms") | "mobile forms" |

* * *

### **TRIM**

Returns a string of text with all spaces at both the start and end of the text removed. Any spaces between words are preserved.

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| TRIM(*x*) | *x* is text | Text |

| **Example** | **Result** |
| --- | --- |
| \=TRIM("  Mobile Forms  ") | "Mobile Forms" |

* * *

### **REPT**

Returns a text string composed of the character *x* repeated *n* times.

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| REPT(*x, n*) | *x* is text  <br>*n* is a number | Text |

| **Example** | **Result** |
| --- | --- |
| \=REPT("-", 4) | "----" |

* * *

### **SUBSTITUTE**

Returns a string with all occurrences of *y* in *x* replaced with *z*.

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| \=SUBSTITUTE(*x, y, z*) | *x* is text  <br>*y* is text  <br>*z* is text | Text |

| **Example** | **Result** |
| --- | --- |
| \=SUBSTITUTE("loonie toon", "oo", "u") | "lunie tun" |

* * *

### **FIND**

Returns a result which is the location of the first occurrence of *x* in *y*, after the *n*th character, or zero if *x* does not appear in *y*. *n* is treated as 1 if it is less than 1 (the first character). The result is always zero if *n* is greater than the length of *y*, since *x* will never appear after the end.

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| FIND(*x, y, n*) | *x* is text  <br>*y* is text  <br>*n* is a number | A number |

| **Example** | **Result** |
| --- | --- |
| \=FIND("oo", "loonie toon", 1) | 2 |
| \=FIND("oo", "loonie toon", 2) | 2 |
| \=FIND("oo", "loonie toon", 3) | 1 |
| \=FIND("oo", "loonie toon", 10) | 0 |
| \=FIND("u", "loonie toon", 1) | 0 |