Macro to conanceate three cols.

Hello all,
I am wanting to get a simple macro that can give me the results I have in col CE.

The function in col CE is conanceating cols BJ, BK, and col BL only.
I have 16,276 rows to result.

The data starts in col BJ and moves right, if col BK contains data then col BJ will never be blank. If col BL contains data, then cols BJ and BK will never be blank.
There will be blank cells in all three cols, so result is the same as example.

The data contains numbers and text only.

Thanks.

This:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks Trevor, I'm having trouble where your results go into my worksheet, can you provide a sample please.
Thanks.

See the attached updated sample workbook.

The code is in the module mConcat. There's a very basic version and a more sophisticated version that converts the formulae to values.

Please Login or Register  to view this content.

Perfect, thanks again Trevor.
I ran the macro over a 214,000 row sheet and with my clunky old computer it processed in less than 3 seconds.
Just a note for others, I have been using this -, to separate when conanceating. It causes the little green arrow in top left corner of some cells, and they never go away, even when you re-open the sheet.
I going to use the Asterix from now on. ***.

Thanks again Trevor.

You're welcome. Thanks for the rep.

I tend to use a vertical bar ( | ) as a separator for something like this. On advantage of not using a dash ( - ) is that you wouldn't need to keep changing the cell format