ANDIF Formula

[mikeywhits]

Hi all,

I have 3 cells A1, B1, C1

Cell A1 will either be blank or "R".
Cell B1 will either be blank or "A".
Cell C1 will either be blank or "G".

When 1 cell has a letter the other 2 cell are always blank.
Is there anyway of creating an ANDIF formula (i assume), which will capture only the cell with a letter in?

Thanks,

 

[mikeywhits]

Just tried Ruddles formula and appears that the simplist works on this occassion. thanks for the help all