#11

wickedchew wickedchew is offline

Senior Member

Location: Philippines

Posts: 161

Quote:

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

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

__________________
Asobi Wa Owari Da

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Text Extraction (parsing)	Curtis	Excel Worksheet Functions	3	October 21st 09 08:35 PM
Parsing text	Confused	Excel Worksheet Functions	1	August 5th 09 03:38 PM
parsing text	KRK	New Users to Excel	4	March 8th 08 05:23 PM
parsing text	[email protected]	Excel Discussion (Misc queries)	1	April 11th 07 01:29 PM
Parsing text	Hamster07	Excel Discussion (Misc queries)	3	February 1st 07 07:32 PM

All times are GMT +1. The time now is 06:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us