Arraytotext format change

[Dave Carr QM]

I have used the Arraytotext function to extract the content of 6 cells in a row, the output is displayed with each value separated by a comma.

BRD, PS, BP, TN, E, 1024

Is there a way of the cell displaying the output separated by a hyphen ?
BRD-PS-BP-TN-E-1024
I have tried to copy cell to another and use replace but this did not work.
Thanks

 

[Fluff]

Hi & welcome to MrExcel.
It sounds like you need to use the textjoin function.

 

[Dave Carr QM]

Hi & welcome to MrExcel.
It sounds like you need to use the textjoin function.

Many Thanks Fluff, that's sorted one issue, will post another couple issues later.

 

[Fluff]

You're welcome & thanks for the feedback.