"capnhud" wrote:
And if i wish to put other information in column B
will that information be affected by the formula

Of course! <g
A cell can only contain a value or a formula at any one time.

If needed, we could copy the formula returns in col B
and do a paste special check "values" ok
to overwrite col A. And then just delete / clear col B
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--