Hello all,
I'm currently trying to extract numbers from a column that is formatted as follows:
Blah Blah For Blahing (0284)
And am using this function which generally works:
=MID(I2, SEARCH("(", I2) + 1, SEARCH(")", I2) - SEARCH("(", I2)-1))
Which works BEAUTIFULLY, EXCEPT in the case of something like this:
Blahdiblah (BDB) (0247)
Which returns the acronym instead of the number.. I thought I came up with a really elegant solution by putting this out there:
=IF(ISNUMBER(MID(I2, SEARCH("(", I2) + 1, SEARCH(")", I2) - SEARCH("(", I2)-1)),MID(I2, SEARCH("(", I2) + 1, SEARCH(")", I2) - SEARCH("(", I2)-1), "WHY?!")
But the ISNUMBER function is returning as false even when I isolate the =ISNUMBER(MID.... etc
Any help on this or anything I'm missing that would make it return false like it is? I'm now realizing that I'll have to do some other magic to skip the text even if this does resolve as TRUE, but I'll get to that?
Thanks in advance!
I'm currently trying to extract numbers from a column that is formatted as follows:
Blah Blah For Blahing (0284)
And am using this function which generally works:
=MID(I2, SEARCH("(", I2) + 1, SEARCH(")", I2) - SEARCH("(", I2)-1))
Which works BEAUTIFULLY, EXCEPT in the case of something like this:
Blahdiblah (BDB) (0247)
Which returns the acronym instead of the number.. I thought I came up with a really elegant solution by putting this out there:
=IF(ISNUMBER(MID(I2, SEARCH("(", I2) + 1, SEARCH(")", I2) - SEARCH("(", I2)-1)),MID(I2, SEARCH("(", I2) + 1, SEARCH(")", I2) - SEARCH("(", I2)-1), "WHY?!")
But the ISNUMBER function is returning as false even when I isolate the =ISNUMBER(MID.... etc
Any help on this or anything I'm missing that would make it return false like it is? I'm now realizing that I'll have to do some other magic to skip the text even if this does resolve as TRUE, but I'll get to that?
Thanks in advance!