HELP Excel Formula: concatenate if cells (col) is not blank

[harky]

concatenate if cells (col) is not blank

anyone can help me

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]H[/TD]
[TD]K[/TD]
[TD]L (Result)[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD][/TD]
[TD]no result due to K is blank.
Formula here[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]D[/TD]
[TD]ABCD[/TD]
[/TR]
</tbody>[/TABLE]

 

[Michael M]

Try

=IF(OR(H1="",K1=""),"",H1&K1)

 

[harky]

Thanks man!!!
work great

Try

=IF(OR(H1="",K1=""),"",H1&K1)

 

[Michael M]

Glad to help...