Let's begin with the Slice function:

SLICE → Extracts a substring from a string from the start index (inclusively) to the end index (optional and exclusively).

• Syntax → slice(text, number, number)

Slice @ From Twitter Handle Formula

slice(prop("Handle"), 1, 50)

Let's take this one step further and generate twitter links with the handles.

*Note: These links are not clickable. However, if table is exported to CSV, links are clickable.

Twitter Link With Sliced Handle Formula

"https://twitter.com/" + slice(prop("Handle"), 1, 50)

COPY TEMPLATE