SLICE

Breaks text by order around the delimiter and retrieves one word.

Parameter List

Syntax
SLICE(textdelimiterposition)
text

The text to be broken into slices.

delimiter

The character or characters to use to split text.

position

The slice element that you want to obtain. The first element is 1. Use the exact number to get a specific slice. Use a negative number to start the counting from the last element.

Examples

SLICE("John Peter Smith", " ", 1) returns John