Hi Dave,

This is a seemingly simple issue, but not? If a user enters a nickname
in C2 (deleting the underlying formula =B2), then deletes the nickname,
the formula =B2 needs to be re-applied to C2. Adding an additional
scratch column won't help because the C2 cell will still not have the
formula. Is there a way to store a relative formula, and then apply it
if a cell is blank or null?

Thanks again,

Arnold