(Solved) – Get value between brackets inside single cell

(solved)-–-get-value-between-brackets-inside-single-cell

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.

Leave a Reply

Your email address will not be published. Required fields are marked *