I’d like a formula to remove the [1][2] instances from the column data

How to remove [1],[2] from list of data

I’d like a formula to remove the e1]12] instances from the column data

Page 1 / 1

IF({First Nations}, REGEX_EXTRACT({First Nations}, "[^\\[]*"))

The regular expression effectively says: grab everything up to—but not including—the first square brace.

IF({First Nations}, REGEX_EXTRACT({First Nations}, "[^\\[]*"))

The regular expression effectively says: grab everything up to—but not including—the first square brace.

Perfect, works great thank you!