|
|
#4
04-23-2018, 04:53 PM
|
|||
|
|||
Sorry, I must have missed what was to be done with the results so just displayed them as they were being extracted in a message box in order to see the results.
You need to replace the MsgBox line with the cell address(s) you're wanting the result(s) to go in to. For a more accurate/specific answer more information is required. What's the sheet name? What column? All in one cell or ??? 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Extract a string from a paragraph
|
kirkm | Word VBA | 7 | 09-11-2016 06:13 PM |
| How to extract only numbers from a STRING? | Learner7 | Excel | 3 | 07-02-2013 06:25 AM |
|
Extract Numbers from Alphanumeric String
|
OTPM | Excel | 6 | 05-13-2011 12:52 AM |
| Extract numbers from a text string | aleale97 | Excel | 4 | 02-10-2011 10:33 AM |
| Extract from String using Wildcard | whousedmy | Word | 0 | 05-21-2009 01:35 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode