IF OR Statement checking 2 cells

[JTL9161]

I have 2 cells
A1 contains ABC DEFG
B1 contains XYZ 1234

in cell C1 I need the formula to look at A1 and B1 and what cell contains ABC to copy that value (ABC DEFG) to cell C1

Note that the ABC value will always be at the beginning of the text.

Thank you
Happy Holidays
James

 

[Fluff]

What happens if neither start with ABC?

 

[JTL9161]

What happens if neither start with ABC?

I could say leave it blank but either one will contain ABC

 

[Fluff]

In that case how about

=IF(LEFT(A1,3)="ABC",A1,B1)

 

[JTL9161]

Thanks.

 

[Fluff]

You're welcome.