Concatenate one or multiple cells with ;

[qzqzjcjp]

Hi,

I would like to concatenate the source from three cells in sequence with ";". The easiest one is

Please Login or Register  to view this content.

, However, the result in the three cells are changing and could be blank. As an example, if only the 3rd source has value and the other two are blank, the expected combined result is "Source3", not ";;Source3". I know that it can be achieved by a long "IF" statement. But I am wondering if there is a better way with a shorter formula?

Please see the attached example.

Thank you very much

[tanasedn]

Please update your profile with the Excel version you actually have. In 2010 the CONCAT function does not exist.
I think you have a function TEXTJOIN

Please Login or Register  to view this content.

[qzqzjcjp]

Thank you very much tanasedn!!!

[tanasedn]

You're welcome!