Formula help...
 

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

=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

In column B
=IF(LEFT(A1)="@","",A1)
In column H
=IF(LEFT(A1)="@",A1,"")

--
Regards
Roger Govier
"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

Roger, that is what I wanted but is there a way to have it get rid of the
blank cells at the same time? Right now it gives me
OAK
OAK
OAK



NYY
NYY
NYY

Is there a way to have the NYY move to right underneath the OAK? Thanks.

"Roger Govier" wrote:

In column B
=IF(LEFT(A1)="@","",A1)
In column H
=IF(LEFT(A1)="@",A1,"")

--
Regards
Roger Govier
"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