Ernie Colon How Do I Switch A List Of Names And Numbers Separated By A Colon?

How do I switch a list of names and numbers separated by a colon? - ernie colon

I have a list of individuals and their identification numbers after the colon between them.
Example:
Abe: 22
Bob: 67
Candy: 12
Doris: 32
Ernie: 45
Ethel: 67
Modifications to the list (actually, at 200):
12: Candy
22: Abe
32: Doris
45: Ernie
67: Bob
67: Ethel

I use Word. I have Excel, but do not know enough.