I understand your question Sled. I have the same question. I can put MSFT in
Excel and it offers the smart tag drop down. I can put in HAMP and it works.
I put in SU which is the symbol for Suncor and it does not offer the smart
tage drop down. Maybe it wants to see four characters. I will experiment.

"Sled" wrote:

> Good tip but it's length is 1.
>
> thanks
>
> "David McRitchie" wrote:
>
> > Not familiar with that but perhaps you have an extra character
> > =LEN(A2) should be 1 for a symbol of "T"
> > if it is not perhaps you might use TrimALL macro at
> > http://www.mvps.org/dmcritchie/excel/join.htm#trimall
> > ---
> > HTH,
> > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> > My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> > Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> >
> > "Sled" <Sled@discussions.microsoft.com> wrote in message news:D9AA0C13-F6DF-457B-A52A-1E9FA711E52D@microsoft.com...
> > > Having problems with the Smart Tag recognizing Stock Symbols. Sometimes it
> > > does and sometimes it doesn't. Like "T" for AT&T it doesn't recognize it but
> > > "MSFT" it does. It'd be nice if I could format a cell for a Smart Tag.
> > >
> > > It's a nice feature, I like it.
> > >
> > > thanks
> > >
> > >
> > >
> >
> >
> >