Excel Forum

Mr Excel & excelisfun Trick 57: Extract Many Years from Just Two Years

See Mr Excel and excelisfun take the text string "1997-2000" and create a row of years consisting of 1997, 1998, 1999, 2000. See the functions LEFT, RIGHT, COLUMNS and IF functions. VBA or Formula. Learn about the difference between numbers and text for Logical Formulas.

Got a Question? Ask it Here in the Forum.