WELL....afer *carefully* re-reading the request...and realizing that my first
post missed the mark.

Here's an option that you could try
=IF(AND(LEFT(A1,1)="7",ISNUMBER(SEARCH(LEFT(C1,1), "ATG"))),A1&B1&C1,"")

Note: Instead of using the CONCATENATE function, you can just link the text
values to be joined by ampersands (&)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

Try this:

IF(OR(AND(LEFT(A1,1)="7",LEFT(C1,1)="A"),LEFT(C1,1 )="T",LEFT(C1,1)="G"),A1&B1&C1,"")

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Jan Buckley" wrote:

I need to create a formula that says IF LEFT(A1,1)="7" AND LEFT(C1,1)="A" OR
LEFT(C1,1)="T" OR LEFT(C1,1)="G", THEN CONCATENATE(A1,B1,C1)

I don't know if I can use AND and OR in the same formula, or how to string
it all together. Help, please. Thank you.