help with formula...if --> concatenate

S

sedonovan

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

is this possible?

where am I going wrong?

sorry to be a pain!
 
F

Franz Verga

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!
Click to expand...


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
 
Top