|
|
#2
02-05-2016, 09:06 PM
|
|||
|
|||
You say it works if middle initial has no period, but for line 9 it did not find a period, so the error return was a null, not the "R". The non-error return was the result of the formula, whose MID value suffered from the failed FIND getting a #VALUE! error -- at which point the -1,2 part is meaningless.
If I'm right so far, then line 10 also suffers because it depends on finding a period. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how to split merged data into vertical saperate cells | cheekugreat | Excel | 5 | 10-11-2014 05:53 AM |
 How to format WORD data using edit field?
|
Azuki | Mail Merge | 2 | 04-01-2013 06:08 PM |
| Merge field source data field | kckay | Mail Merge | 4 | 03-25-2013 11:06 AM |
|
Mail Merge - If a field is black, take the data from the row below?
|
mikeprent | Mail Merge | 5 | 01-05-2012 04:52 AM |
|
Split Data from One Cell Into Two
|
Karen615 | Excel | 3 | 09-20-2011 06:36 AM |
Windows 7 64bit 
Office 2007
Threaded Mode