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?
Electronic Services and Serials Librarian
Virginia Theological Seminary
3737 Seminary Road
Alexandria VA 22304
[log in to unmask]