=COUNTIF(A:A,"@*")
and
=COUNTIF(A:A,"<@*")
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Jambruins" wrote in message
...
In column A there are cells with team names in them like the following:
NYY
NYY
NYY
@OAK
@OAK
@OAK
BOS
BOS
BOS
@TEX
@TEX
@TEX
I would like column B to list all the team names without the @ symbol and
column H to list all the teams with the @ symbol. For the example I would
like column B to have
NYY
NYY
NYY
BOS
BOS
BOS
|