Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Text parsing HELP
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. |
#2
|
|||
|
|||
Quote:
=RIGHT(A1,LEN(A1)-5)
__________________
Asobi Wa Owari Da |
#3
|
|||
|
|||
Quote:
Thanks again. |
#4
|
|||
|
|||
Quote:
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)
__________________
Asobi Wa Owari Da |
#5
|
|||
|
|||
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")?
|
#6
|
|||
|
|||
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")?
|
#7
|
|||
|
|||
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")?
|
#8
|
|||
|
|||
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")?
|
#9
|
|||
|
|||
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")?
|
#10
|
|||
|
|||
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")?
|
#11
|
|||
|
|||
=IFERROR(MID(B1,FIND("CVE: ",B1)+5,13),"")
__________________
Asobi Wa Owari Da |
#12
|
|||
|
|||
Great, that did the trick.
Thanks again! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Extraction (parsing) | Excel Worksheet Functions | |||
Parsing text | Excel Worksheet Functions | |||
parsing text | New Users to Excel | |||
parsing text | Excel Discussion (Misc queries) | |||
Parsing text | Excel Discussion (Misc queries) |