Hello,

I am having trouble concatenating the following. I receive a VALUE error

I am trying to combine the two fields of data and add a dash between them.

Column A data is 10-2314-001 and Column B is S595695. I am trying to combine them in Column C show they show as 10-2314-001-S595695. I am using formula =concatenate(A1,-B1)

I think the problem is because the data in Column A has dashes that I need to retain.

Does anyone know of a way around this?

Thanks all for your help