View Single Post
  #11   Report Post  
wickedchew wickedchew is offline
Senior Member
 
Location: Philippines
Posts: 161
Default

Quote:
Originally Posted by jdavistdi View Post
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")?
=IFERROR(MID(B1,FIND("CVE: ",B1)+5,13),"")
__________________
Asobi Wa Owari Da