D
David
I need a formula to parse text that looks something like this to extract the
data contained in parentheses.
FI-SL: Local Posting Periods (GCP1)
I was using the following formula which worked just fine ...
=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)
....until I ran into text with another left parentheses to the left of the
data I want to extract.
C FI Copy company code (G/L account) (OBY2)
Unfortunately the FIND function doesn't provide an option to go from right
to left otherwise this would be easy. Is there another way to extract OBYA
from the text above via formula that will also work on the earlier example?
Thanks in advance!
data contained in parentheses.
FI-SL: Local Posting Periods (GCP1)
I was using the following formula which worked just fine ...
=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)
....until I ran into text with another left parentheses to the left of the
data I want to extract.
C FI Copy company code (G/L account) (OBY2)
Unfortunately the FIND function doesn't provide an option to go from right
to left otherwise this would be easy. Is there another way to extract OBYA
from the text above via formula that will also work on the earlier example?
Thanks in advance!