I just tried entering the =UPPER() formula for the column. It works on a new
entry, and unless I am not using the syntax correctly, it does not change
existing entries.

Column name is UMB

John

"Jim Thomlinson" wrote:

In Excel you can use the formulas
Upper & Lower

In VBA you can use
UCase & LCase

It depends houw you want to approach the problem...
--
HTH...

Jim Thomlinson


"john d" wrote:

Is there a way to change all the entries in a column from lower case to
upper case?