M_W - profile

M_W · Aug 31, 2020

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 Welbo...

M_W · Sep 01, 2020

Thanks Scott! It works perfectly well except for cells with a period (see screenshot below). Is there a way to make the value() formula work?

User Statistics

User Activity

Extract four digit number from cell (i.e. year from citekey)

Re: Extract four digit number from cell (i.e. year from citekey)