Forum Discussion
formula Excel help
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(...
=IF(Import!F2="";"";Import!F2)&" "&IF(Import!G2="";"";Import!G2)&" "&IF(Import!H2="";"";Import!H2)
Does this work?
Many thanks. This works perfectly 👍