TextJoin Formula

[Richard2542]

I am attempting to combine 2 adjacent columns of data into 1 text string (see attachment) using the TextJoin formula - I need to separate each combined result with a semi-colon.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Maybe

=TEXTJOIN({" - ","; "},,A6:B11)

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: TextJoin Formula Suggested Solution
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Richard2542]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Maybe

=TEXTJOIN({" - ","; "},,A6:B11)

Thanks so much, it works; not sure about the formula double ", (comma)"...I've never seen or uses this.

 

[Richard2542]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Maybe

=TEXTJOIN({" - ","; "},,A6:B11)

Fluff, I'm using Office 365

 

[Peter_SSs]

Thanks so much, it works;

The marked solution has been changed accordingly.
In your future questions, please mark the post as the solution that answered your question instead of your feedback message as it will help future readers. No further action is required for this thread.

 

[Fluff]

Thanks so much, it works

Glad to help & thanks for the feedback.

 

[Richard2542]

Fluff...can your excellent formula be altered to SORT the data by RANK (data shown in cells A6:A9)?

 

[Fluff]

How about

=TEXTJOIN({" - ","; "},,SORT(A6:B11))

 

[Richard2542]

How about

=TEXTJOIN({" - ","; "},,SORT(A6:B11))

This works, I'd like to include Player Name -