Another one
B1
=SUBSTITUTE(REPLACE(A1,FIND("(",A1&"("),IFERROR(MATCH(2,INDEX(1/(MID(A1,ROW(INDIRECT("1:90")),1)=")"),))-FIND("(",A1)+2,),"")," *","")
Another one
B1
=SUBSTITUTE(REPLACE(A1,FIND("(",A1&"("),IFERROR(MATCH(2,INDEX(1/(MID(A1,ROW(INDIRECT("1:90")),1)=")"),))-FIND("(",A1)+2,),"")," *","")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks