A few strokes shorter.............

=LEFT(C5&D5&E5&F5&G5&H5,1)

Vaya con Dios,
Chuck, CABGx3


"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
George,

In cell J3:

=IF(COUNTIF(C5:H5,"a")0,"a","")

HTH,
Bernie
MS Excel MVP

"George Gee" wrote in message
...
Hi all

How can I express this as a formula:

In J3:

If any cell in the range C5:H5 contains "a", then J3 contains "a"

Cells C5:H5 contain only "a", or are blank.

Many thanks


George