Sorry Stan you are correct I meant if I enter BT2 in A1 (with the number
part variable) it enters Bob Todd in A2

Thanks

Mark

PS how's the snow?
"Stan Brown" wrote in message
t...
On Sat, 9 Feb 2013 17:36:50 -0000, Mark wrote:

If I enter 'BT2' in A2 I would like text Bob Todd to appear in
cell A2. Is this possible could someone help me with the formula please.

There is no worksheet formula that can cause a cell to overwrite
itself. Either you made a mistake in describing what you want, or
you'd have to use a VBA macro that's triggered by the Change event.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...