combine contents of multiple cells in single cell

[sainil]

would like to combine contents of multiple cells in a single cell as shown below
cell A1 asdf
cell A2 zxcv
cell A3 qwer

requirement is cell B1 should have
asdf
zxcv
qwer

thanks

existing Required
[TABLE="width: 500"]
<tbody>[TR]
[TD]asdf
[/TD]
[TD]asfd
zxcv
qwer
[/TD]
[/TR]
[TR]
[TD]zxcv
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]qwer
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Special-K99]

http://www.mrexcel.com/forum/excel-questions/310164-concatenate-line-break.html