=IF(RIGHT(A1,1)="1","ISDN","Highway")

for a telephone number in cell A1.

HTH
--
Allllen


"Sean" wrote:

I want to determin a telephone number.
I know that if a telephone number ends in a one (1) then it comes from a
certain type of service, so what I need is a formular that says
if (Tel No) does not end in 1 then Highway otherwise ISDN
I can then copy this formular to the other numbers in the range