Sir,

I have a data in which Column A contains date B contains programmes. I am
trying to get in column C that if date starts with 1 a particular programme
from B and if start with 15 some other programme. when i put the formulah
=left(A1,2) it brings 39 as answer. Is there any idea that how I can bring
the first two digits from the date column with out considering the month &
year.

thanks