Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Search and extract | Excel Programming | |||
Wildcard search for string within a string? | Excel Programming | |||
to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
search a string withing a string : find / search hangs | Excel Programming | |||
VBA function : How to search a string in another string? | Excel Programming |