Concatenate if data

[lesley burlingham]

I have a piece of code below which adds a field if he answer is x. Is it possible to have it add the field if anything is placed into the cell.
Code below. =CONCATENATE(IF(F62="x",Request!B62&",","")&" "&IF(F63="x",Request!B63&",","")&" "&IF(F64="x",Request!B64&",",""))

 

[Faseeh]

Hi Lesley,

What do you mean by field?

 

[NARAYANK991]

Hi Lesley ,

Try this :

=SUBSTITUTE(TRIM(CONCATENATE(IF(F62<>"",Request!B62&" ","") & " " & IF(F63<>"",Request!B63&" ","") & " " & IF(F64<>"",Request!B64,"")))," ",",")

Narayan