Quote:
Originally Posted by jdavistdi
Thanks for the quick reply! Can you clarify how the formula above will find the "CVE:" specific text in the cell as opposed to all the other text that is there?
Thanks again.
|
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)