I currently have a spreadsheet to keep track of scores in a card game. There can be between two and five players. I have the following:
| Players | |----------| | Dave | | Paul | | John | | | | |
At the moment I use:
= JOIN( " vs " ; C10:C14 )
But the problem is I then end up with
Dave vs Paul vs John vs vs.
Is there a way to make it say
Dave vs Paul vs John but if I had more players,
Dave vs Paul vs John vs Rob with one formula?