#Value error when concatenating an alpha-numeric cell?

[JTru77]

I'm trying to concatenate two columns of cells in Excel 2010. One is the name of a supplier, the other is a 5 digit account code. Some of the codes are fully numeric and some are alpha-numeric. I'm using this formula: =CONCATENATE(A2, - B2) in order to get a dash between the two parts. It is working with all the numeric values, but returning a #VALUE error with the alpha numeric values. I can get it to work if I remove the dash/space, but then it's all one word. Any ideas why or how to fix it?

Here is an example:[TABLE="width: 1109"]
<tbody>[TR]
[TD][TABLE="width: 888"]
<tbody>[TR]
[TD]BULKLEY SOCIETY[/TD]
[TD]71460[/TD]
[TD]BULKLEY SOCIETY-71460[/TD]
[/TR]
[TR]
[TD]VALLEY BACKPACKERS INC[/TD]
[TD]71461[/TD]
[TD]VALLEY BACKPACKERS INC-71461[/TD]
[/TR]
[TR]
[TD]CAMP MORICE SOCIETY[/TD]
[TD]71TJA[/TD]
[TD]#VALUE ![/TD]
[/TR]
[TR]
[TD]CAMPBELL RIVER SALMON FESTIVAL SOCIETY[/TD]
[TD]7183A[/TD]
[TD]#VALUE ![/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Welcome to the Board!

Try:

=CONCATENATE(A2, "-",B2)

 

[JTru77]

D'oh, I knew it didn't look quite right (haven't used that one in a while!). It worked! Thank you

 

[Joe4]

You are welcome!

I am a little lazier and would just do it this way:

=A2 & "-" & B2