Nel post
*sedonovan* ha scritto:

=IF(A4<"","=CONCATENATE(sheet1!A4,sheet2!B4,"txt" )","")

is this possible?

where am I going wrong?

sorry to be a pain!


Hi Sedonovan.

Two way:

=IF(A4<"",CONCATENATE(sheet1!A4,sheet2!B4,"txt"), "")

but I prefer this one:

=IF(A4<"",sheet1!A4&sheet2!B4&"txt","")


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy