We're setting up your new app...


Split on Newline LK

How to extract a particular line from text

Industry: n/a
Function: Other
This app shows how to extract lines from multi-line text using the SPLIT and INDEX functions.

How we built this app

To split the text into lines, we use this formula: SPLIT([Text], " ") Next, to access a particular line, we use this formula: INDEX([Split Text], 2) (That will return the second line.)
This is a preview of the data sets used in the app.


This is a high-level model of both the data entities and the UI elements in the app.
Start for free