![]() |
|
|
|
#1
|
|||
|
|||
|
Greg,
Thanks for the quick response. It is working with one small flaw. It is capturing other numbers that are not enclosed in "(CCI:" and ")". If I had to guess, which I have to or I wouldn't need your help, I think it is identifying number (CCI: 000123) and stripping off the on the first pass "(CCI:" and ")" leaving 000123 in the array. On the second pass it finds the "naked" 000123 number and captures that along with the page number. Is there any way to resolve this? Also, I realize that I may be asking for too much but I have several entries that appear as (CCI: 000123-000125). Is there a method to have that captured as: 000123 000124 000125 |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Extract Bold text from string
|
one4youman | Word VBA | 8 | 04-18-2019 12:31 AM |
| Formula to Extract text from a text string | Haha88 | Excel | 2 | 11-14-2017 01:32 AM |
Extract text from a text string
|
Haha88 | Excel | 8 | 02-13-2017 05:06 PM |
| 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 |