#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:

BULKLEY SOCIETY 71460 BULKLEY SOCIETY-71460 VALLEY BACKPACKERS INC 71461 VALLEY BACKPACKERS INC-71461 CAMP MORICE SOCIETY 71TJA #VALUE ! CAMPBELL RIVER SALMON FESTIVAL SOCIETY 7183A #VALUE ! <tbody> </tbody>

<tbody>
</tbody>

 

[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