Can you live with something like:

(1),(2),(4)

If yes, you could use this formula in B1:

=SUBSTITUTE(TRIM(IF(A1="","","(1) ")
& IF(A2="","","(2) ") & IF(A3="","","(3) ") & IF(A4="","","(4) "))," ",",")



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

--

Dave Peterson