Converting the selection to UPPERCASE

I just receive a list of participant, but I wanna to change all the participants name to uppercase.
I decided to use Excel VBA to help me to do this.

I create the following code in a PERSONAL.XLSB so I can use it again and again on my machine.

Here is hte code

Sub ToUpper()

   

    For Each cell In Selection

        ' Convert all the selected cells to UPPERCASE

        cell.Value = UCase(cell.Value)

    Next

End Sub

It really simplify my work. Hope this helps you too.