Though no on screen explanation was given to Mr. Handford's departure, Sesame Workshop's official website cites that Mr. Handford simply sold the store to Alan in 1998.
Check out a montage of the many projects he worked on:
Below he talks with "Everyday Philly" about his life and career:
RIP David Smyrl. you'll alway be Mr. Handford to us!