#Value when trying to concatenate

[lsweeney]

Hi,

I am trying to concatenate two cells with a dash in the center. I have never had a problem like this where it just won't calculate. I don't know if it is the settings in the spreadsheet (not mine) or something else. If I try a simple =Right it will not calculate. Here is an example of sheet where I am trying to concatenate the cells in B18 with a dash then C1. Anyone know why this is happening? Thank you in advance!

 

[Fluff]

What formula are you using?

 

[lsweeney]

=concatenate(b18,"-",c1)

 

[Fluff]

Nothing wrong with that, you could try textjoin

+Fluff v2.xlsm
	A	B	C	D
1			59
13
14
15
16
17				4015-59
18		4015		4015-59
Main

Cell Formulas
Range	Formula
D17	D17	=TEXTJOIN("-",,B18,C1)
D18	D18	=CONCATENATE(B18,"-",C1)

What exactly do you have in B18 & C1?