LEFT

Formula Explanation

Returns the first n characters of a string.

Formula Syntax

left("text / column number")

• Both parameters can use column references, which are the CODEs at the top of each column in the table. For example: AA1.

Usage Example

Get the first 4 characters from column DD2 and write the result into column DD3.

DD3 = left(DD2, 4)

✉️ Ask Tablize