I have zero Excel skills, but chances are you could do this with any 
scripting language if you were to export the file as text (e.g. CSV).
-Jon

On 07/02/2013 11:02 AM, Harper, Cynthia wrote:
> Is there a way to return (in Excel, if possible) the largest 4-digit number (by word boundaries) in a string?  I've extracted the 863 fields from Millennium for my active periodicals, and want to find the latest year in each run.  I'm willing to estimate it by taking the largest 4-digit number in the string. I'm doing this in Excel.  Any help?
>
> Cindy Harper
> Electronic Services and Serials Librarian
> Virginia Theological Seminary
> 3737 Seminary Road
> Alexandria VA 22304
> 703-461-1794
> [log in to unmask]