Hi, for my academic research database I’m trying to write a formula that will automatically extract a four-digit number from a cell (i.e. extracting year from a citekey).
For example (Citekey --> Year),
Downs1965NonmarketDecisionMaking --> 1965
Welborn1968BureaucracyAnthonyDowns --> 1968
Any ideas on how I might be able to do this? Thanks.