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
[email protected]
