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

[Viet_Nguyen]

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

[Justin_Barrett · Accepted solution]

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

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

[Viet_Nguyen]

Perfect, works great thank you!