Quote:
Originally Posted by wickedchew
You can only apply the formula if the cell only contains "CVE: xxx."
But if the cell contains this information:
High / CVSS Base Sco 7.5
CVE: CVE-2010-0219
BID: 44055
Other references: CERT:989719
You need to use another formula:
=MID(B1,FIND("CVE: ",B1)+5,13)
|
Thanks, that seems to be doing the trick! One other question, what if I wanted to add IF ERROR to get disregard any cells that don't have the text above? How do I add it to the formula you have? Is it something like: =IFERROR(D116:D2786,"NA")?