---
title: Text
slug: eEgo-text
docTags: 
createdAt: 2025-09-22T04:59:36.000Z
---

### Char

**Description: **Returns the character whose number code is defined in the parameter.

**Example: **

*Char(number)*

### Clean

**Description: **Removes the non-printable characters from the given text, represented by number 0 to 31 of the 7-bit ASCII code.

**Example: **

*Clean(text)*

### CONCATENATE

**Description: **Joins arguments into a single string.

**Example: **

*CONCATENATE (text1, text2,...)*

### Dollar

**Description: **Converts a number to text, using a currency format.

**Example: **

*Dollar (number, decimal\_places)*

### LEFT

**Description: **Returns the first character or characters in a text string, based on the number of characters you specify.

**Example: **

*LEFT(text, num\_chars)*

### LEN

**Description: **Returns the length of a string .

**Example: **

*LEN(text)*

### Lower

**Description: **Converts all characters in the specified text string to lowercase. Characters in the string that are not letters, are not changed.

**Example: **

*Lower(text)*

### MID

**Description: **Returns a text segment of a character string.

**Example: **

*MID(text, start\_position, num\_chars)*

### RIGHT

**Description: **Returns the last character or characters in a text string, based on the number of characters you specify.

**Example: **

*RIGHT(text, num\_chars)*

### SUBSTITUTE

**Description: **Substitutes new\_text for old\_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string use REPLACE when you want to replace any text that occurs in a specific location in a text string.

**Example: **

*SUBSTITUTE(text, old\_text, new\_text, instance\_num)*

### TEXT

**Description: **Returns a formatted string.

**Example: **

*TEXT(value, format\_text)*

### Trim

**Description: **Returns a text value with the leading and trailing spaces removed.

**Example: **

*Trim( text )*

### Upper

**Description: **Converts all characters in a text string to uppercase.

**Example: **

*Upper( text )*

### Value

**Description: **Returns a number from a string.

**Example: **

*Value(range)*