Hi,
I have a need to extract text from a cell thats always between "(" and ")".
Cell always contains some text between "(" and ")", and it's(almost) always at the end.
But all the text after and before it's very variable, so I can't use simple left or right function and than to get it that way.
I need some formula that can extract text between "(" and ")". That's the only "fixed" characters that aren't allowed to be anywhere else in cell. And the text between is what I seek to get
I have a need to extract text from a cell thats always between "(" and ")".
Cell always contains some text between "(" and ")", and it's(almost) always at the end.
But all the text after and before it's very variable, so I can't use simple left or right function and than to get it that way.
I need some formula that can extract text between "(" and ")". That's the only "fixed" characters that aren't allowed to be anywhere else in cell. And the text between is what I seek to get