if you have more than one set of matchings text/number sets may help
<A
HREF="http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.misc&lang=e n&cr=US"this thread</A may help

http://www.microsoft.com/office/comm...ang=e n&cr=US
--
paul
remove nospam for email addy!



"Racingzeus" wrote:

BHi All,
I am new to excel, so any help would be great :)
I want to automatically insert a set text string for instance, ABC into A1
only if there is a number inserted into cell B1 for instance 12345.
So if I insert 12345 into cell B1, A1 would then show ABC, if I insert 6789
into B2, A2 would then again return ABC.
However if there is no value in B1 or B2 then I need A1 and A2 to be blank
and not return N/A# etc