I have below values in a cell :
say A5 – ( example are 3 values, it can be ‘n’ values )
Hello Im (User1) Hello Im (User2) Hello Im (User3)
I want to get values inside brackets i.e. User1,User2,User3 in a seperate sheet for further manupulation.
I tried multiple ways but it all works if it has a single value and not multiple values
Below methods i tried
cellValue = "Hello Im (User1)" OP = instr(cellValue, "(") CP = instr(cellValue, ")") EV = mid(cellValue, OP 1, CP-OP-1)
I even tried converting text to column but didnt work.