Hello,

I'm looking to extract text (and numbers) from one column and move them to the adjacent one. I definitely consider myself a novice when it comes to Excel. Here's the gist of what I'd like to do, the data in the column looks as follows:

High / CVSS Base Sco 7.5
CVE: CVE-2010-0219
BID: 44055
Other references: CERT:989719

I want to take just the information following the "CVE:" and extract it to the next column. The trick is that the numbers in the string change and are not constant. For example, in one row, it could be CVE-2010-0219 and the next row, it would be CVE-2008-0312.

What's the best way to do this? I have Excel 2010.