Without VBA you will need a helper column.

=UPPER(A1)

Copy down as far as needed.


Gord Dibben MS Excel MVP

On Thu, 29 May 2008 08:55:01 -0700, Neelakanta
wrote:

how can i captalise the letters in the particular column of excel worksheet.
can it be done through only excel, but not vb programming.

Thanks in advance.
Regards
Neelakanta