Thank you, Greg, for your improvements! I tested my code only on the range made up of words that begin with a capital letter and that are delimited by space. Live and learn (this is my motto). Each your Scratch macro makes me scratch the back of my head in amazement.