One more...

=UPPER(LEFT(A1, 1)) & lower(MID(A1, 2, len(a)))



rodchar wrote:

hey all,
is there an easy way to capitalize just the first letter in a column and
leave the rest as is?

for example,
pubID -- PubID

thanks,
rodchar

--

Dave Peterson