Change 4 to Wiri

[Steved]

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.

 

[Rick Rothstein]

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).

 

[dlotz]

so you want 4517 in a1 and wiri will populate in e1. is this as far it goes
or there over
3's in a1 that need to yeild a diiferent word is so
you need vlookup and then a good sortable table array is not just use a
simple if formula

 

[Fred Smith]

This newsgroup is for people who post in English. There are lots of other
groups for other languages.

Regards,
Fred.