Textjoin?

I've been trying to understand how to use textjoin to make this work but I think I need some help.

I want to join all cells in sheets("race").range("AO2:AQ17) to a single cell. So that the output would look the same as the range but within a single cell and with spaces as a delimiter.

This is what the range looks like:
2017-08-19 09_28_57-Javelin.xlsm - Excel.png

Good morning johandenver

You can use Concatenate or the & operand, thus :

Formula:

Please Login or Register  to view this content.

HTH

DominicB

Thanks, I forgot to mention that I need to do it in vba. How would I use concatenate then?

Thanks :-)

I'm afraid I don't really understand how to put the result into another cell, do I refer to hsv_1 as a variable?

Ok, the thing is that I need to put the concatenated result in a textbox with something like this:

ActiveSheet.Shapes("ScoreBoard").TextFrame.Characters.Text = concatenatednames

So I'm guessing I need to get the result into either a variable or another cell first?

That worked perfectly, thanks a lot! :-)

I ran into a problem with this when using different number formats.

When I use this format (mm:ss,00)
2017-09-05 22_22_56-Clipboard.png

The result becomes this:
2017-09-05 22_23_33-800m.xlsm - Excel.png

It seems that my shape does not understand the number format I'm using.
Is there any way to use the same code but keep the number format?

To clarify, I'd like the result to be this instead:
2017-09-06 11_01_11-800m.xlsm - Excel.png

Here's an example of my problem

Thanks :-)

Simply

Please Login or Register  to view this content.

Sorry, I'm back again with another format. This time I got problems with [m]:ss.00

How would I adapt HSV's or Jindon's code for this format?

Sorry, I'm back with another format. This time it's [m]:ss.00 that's causing problems.

How would I adapt HSV's or jindon's code for this format?

It works when hiding rows but not when hiding columns, for some reason. I need to be able to hide the columns unfortunately.

OK then

Please Login or Register  to view this content.

Lots of thanks to the both of you, you guys are awesome. It worked perfectly.

Hi again,

Is it possible to get the joined text to pick up previous formats as well?
(some of the text joined was previously bold but is not bold when joined together)