Forum Discussion

H-M-P's avatar
H-M-P
Copper Contributor
Apr 12, 2021

Extract text from between characters multiple instances in one cell

Hi   I have an online forms database that, when exported, provides both the field label and value, such that many of the table's columns have redundant data. I would like to eliminate the duplicate...
Formulas and Functions
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Apr 12, 2021

H-M-P 

With Excel 365, you could search for parentheses and then use FILTER and the MID function.

= LET(
    k,    SEQUENCE(LEN(text)),
    strt, 1+FILTER(k,MID(text,k,1)="("),
    end,  FILTER(k,MID(text,k,1)=")"),
  TEXTJOIN(", ", , MID(text,strt,end-strt)))

Resources