CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Salar
Salar

Reputation: 5509

Get subset of string using ARRAYFORMULA

my data has two simple columns, the first column is a string consisting of "/" as delimiter. I want to explode the string and get the second item. I could achieve it using INDEX and SPLIT formulas. How can I rewrite this operation using ARRAYFORMULA?

enter image description here

Upvotes: 1

Views: 73

Answers (1)

player0
player0

Reputation: 1

use this:

=INDEX(SPLIT(A2:A, "/"),,2)

Upvotes: 3

Related Questions