Adding Mark "-" Between Number from 2 columns

[muhammad susanto]

hi all...

how to adding mark "-" between number from 2 columns (joined)
this layout :
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>
[TABLE="class: tableizer-table"]
<thead>[TR="class: tableizer-firstrow"]
[TH]data given
[/TH]
[TH]given[/TH]
[TH]expected result[/TH]
[/TR]
</thead><tbody> [TR]
[TD]4010201008
[/TD]
[TD]6
[/TD]
[TD]4010201008-6
[/TD]
[/TR]
[TR]
[TD]4010201002[/TD]
[TD]45[/TD]
[TD]4010201002-45
[/TD]
[/TR]
[TR]
[TD]3010201011[/TD]
[TD]178[/TD]
[TD]3010201011-178[/TD]
[/TR]
[TR]
[TD]3010201017[/TD]
[TD]5555[/TD]
[TD]3010201017-5555
[/TD]
[/TR]
</tbody>[/TABLE]


any help, greatly appreciated...

-sst.

 

[Rick Rothstein]

Give this formula a try...

=A2&"-"&B2

 

[muhammad susanto]

hi Rick...it's look easy..unfortunaly , i missing it...

thank you!!