|
|
|
|
#1
12-15-2017, 03:33 PM
|
||||
|
||||
For some code to concatenate sequential number ranges, see: https://www.msofficeforums.com/word-...html#post68204
In your case, you'd need to supplement that with code to remove the preceding letters before running the function, then restoring them to each 'group' after it's generated the parsed list.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Can Excel find Duplicate entries when only part of the cell's data is a duplicate of another cell? | jsisley | Excel | 1 | 07-21-2017 09:20 AM |
 Populating ranking depending upon ranges of previous cell's data
|
sryder | Excel | 5 | 04-07-2016 03:37 PM |
| How to replicate, consolidate and count cell data in excel for data consoldation. | Loran | Excel | 7 | 06-05-2014 01:07 AM |
|
Excel 2007, highlight entire row based on data found in one cell
|
MSofficeBLUE | Excel | 2 | 10-15-2013 09:51 PM |
|
putting image file into a cell of a table
|
hklein | Word VBA | 1 | 04-19-2013 03:34 AM |
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode