I’d like a formula to remove the [1][2] 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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.