I have cells A1 through A10 with player names (John, Joan, Tom, etc.)

I would like to generate 5 teams by random. How can I do this with excel?
....without repeating names

Thanks