A formula can only change the cell it is in, so there is no formula you can
put in E1 that will change a constant value in cell A1. There may be other
ways to do what you want, but you will have to provide more information
(such as how the 4517 got into A1 and what is supposed to happen in E1 to
make A1 change).
--
Rick (MVP - Excel)


"Steved" wrote in message
...
Hello from Steved

In Col A1 I've got 4517 in Col E1 I need a formula please That will Change
Col A1 to Wiri.

Yes I know how to do it but I just can't think at this time, how to do it.

I Thankyou.