=upper(a1)
on cell c1
=upper (b1) on cell d1
for your first and last names
Now copy c1 and d1 and paste it all the way down.

Then select column C and D and copy edit paste special values to lose the
formulas.





"vrajna" wrote in message
...
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.