thanks, this fixed it giles...appreciate everyone's help here. Take
care. BULL
Giles (NoSpam) wrote:
Here is a nice simple formula to put in cell B1

=CHOOSE(COUNTA(A1:A4),"(1)","(1)(2)","(1)(2)(3)"," (1)(2)(3)(4)")

hth

Giles

" wrote:

Hello, any help is appreciated. I have four cells (A1 thru A4). I want
to display (1) in B1 if just A1 contains any text, or I want to display
(1) and (2) in B1 if cells A1 and A2 both contain text, or display
(1),(2), and (3) in B1 if A1,A2,and A3 contain text, or display (1),
(2), (3), and (4) in B1 if A1 thru A4 have any text in them.

Sorry if this has already been covered somewhere...I did check...Thanks
for any help guys/gals.

Bull