ExcelBanter - help with formula...if -- concatenate

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - help with formula...if -- concatenate (https://www.excelbanter.com/excel-discussion-misc-queries/95438-help-formula-if-concatenate.html)

sedonovan

help with formula...if -- concatenate

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

is this possible?

where am I going wrong?

sorry to be a pain!

Franz Verga

help with formula...if -- concatenate

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

All times are GMT +1. The time now is 03:34 PM.