|
|
|
|
#1
11-08-2016, 04:39 PM
|
||||
|
||||
Assuming the 999 after THOMAS is just padding (i.e. longer names would have fewer 9s; shorter names, more), you could use formulae such as:
=SUBSTITUTE(MID(A1,6,9),9,"") =RIGHT(A1,4)
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Macro to delete text from cells with specific format
|
Soenke | Word VBA | 4 | 09-01-2016 08:55 AM |
|
Copying Same Value Between Two Cells
|
rsrasc | Excel Programming | 3 | 02-29-2016 10:53 PM |
|
Copying text into multiple cells at once
|
BIMwit | Word Tables | 1 | 05-14-2015 09:50 PM |
| Copying text range of cells to different cells adds an extra line | jpb103 | Word VBA | 2 | 07-23-2014 12:22 PM |
| Macro to Insert Text Into Cells Having Multiple Lines | revans611 | Excel Programming | 4 | 10-24-2011 10:15 AM |
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode