Can I get them separated? Like the A's in one row, the H's in another row
and so on?
--
DMM


"Peo Sjoblom" wrote:

You can't use the same cell, you would need a help cell

=IF(OR(LEFT(C2)="A",LEFT(C2)="H"),1,"")



--
Regards,

Peo Sjoblom



"soconfused" wrote in message
...
I am trying to look at a cell and put a #1 in it:

Example Column C = A-LA41-09-92256 I need a formula
here
to put a # 1 if the value is A- or H-

Thanks in advance.

DMM