'Getting what is in between brackets from a value
I have the following value in a cell:
May 04, 2022 (50bp)
I need only what is in between ( and ). I was thinking of using =RIGHT() but I never know how much is inm between the two brackets (so the number of characters I have to give as a parameter to RIGHT(), will differ.
What is the correct way of handling this in Google Sheets?
Solution 1:[1]
Use REGEXEXTRACT() function.
=REGEXEXTRACT(A1,"\((.*)\)")
Solution 2:[2]
To extract the text between any characters, use a formula with the MID and FIND functions despite how much is in between the two brackets.
=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)
more information here
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Harun24hr |
| Solution 2 |