In microsoft Excel 2003:
Does anyone know of a worksheet function, built in or homemade, that can
replace the contents of a cell when it becomes inactive? I would like to
enter a "b" or an "s" into a cell and have it changed to "Buy" or "Sell" or
any other replacement string as soon as I go on to another cell. Can this
be done?
Thanks.