View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] benbernards@gmail.com is offline
external usenet poster
 
Posts: 1
Default Search for a string and extract it?

Hey guys,
So I'm guessing this will be simple:

I have large blocks of text inside a single cell. I want to search
through the text and extract a single string, as such:

(Contents of a Cell)

blah blah
blah blah
Disk Size: 50 GB <-- I'd like to pull out just "50" and put it in its
own cell
blah blah
blah blah

I'd like to do this via a vba function on a spreadsheet that would
have lots of cells of such text blocks -- so the end result is I have
a list of Disk Sizes that I can then total up.

Any ideas?