Hi Excel community.
I need a little more help cleaning some strings.
Basically I have a variable called Ateam which gets its info from a webpage.
Originally the text was in all uppercase, I have made some changes so that every word gets capital letter like this:
Ateam = "Ayr Utd" or...