formula Excel help

Question

In tab 1, I have three columns on row 2 F, G and H (representing first name, second name and family name)

In tab 2, I want to import column F, G and H combined in one single cell.

I have tried =IF(Import!F2="";"";Import!F2)+IF(Import!G2="";"";Import!G2)+IF(Import!H2="";"";Import!H2) but result wrong #VALUE!

What is the correct formula ?

oliverscheurich · Answer

=IF(Import!F2="";"";Import!F2)&amp;" "&amp;IF(Import!G2="";"";Import!G2)&amp;" "&amp;IF(Import!H2="";"";Import!H2)Does this work?

detlef_lewin · Answer

=TEXTJOIN(" ",TRUE,Import!F2:H2)&nbsp;

huub_maas · Answer

Many thanks. This works perfectly 👍

Forum Discussion