This formula should do it for you...

=UPPER(LEFT(A1, 1)) & MID(A1, 2, 256)
were the text is in A1
--
HTH...

Jim Thomlinson


"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