In B1: =PROPER(A1)

copy down

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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.