i've made a really long list of names (first and last) in two columns in
excel and would like to know if there's a way of capitalizing them without
going through them one by one.

trivial i know but would be greatly appreciated.