I currently have a spreadsheet to keep track of scores in a card game. There can be between 2 and 5 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?