when i put =PROPER(A1) in the C1 cell, then drag it down like you said, all the names that appear in the new column are the name in A1 over and over.