Monty

How many substitutes do you have? You are probably best to set up a
separate table with the substitutes and then use a VLOOKUP formula to pick
them up e.g. if you are entering the data in A1 in B1 enter

=IF(A1="","",VLOOKUP(A1,EnterTheAddressOfYourListH ere,2,FALSE))

This will put nothing if there is not an entry in A1 and if there is it will
look up the text based on the number.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Monty" wrote in message
...
Is there any way i can input certain numbers and they change to words. for
example.
2001 Omagh
2002 Craigavon
2027 Housing Benefit
2036 IT Replacment

any help please
thanks

monty