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)

Originally Posted by jdavistdi

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")?

Originally Posted by wickedchew

=IFERROR(MID(B1,FIND("CVE: ",B1)+5,13),"")