Change case
Upper only works on a single cell. In a column next to the one you want to
convert add the formula (assuming the data is in column A and the desired
result will be in B or where ever the formula is entered) and copy the
formula down...
=Upper(A1)
Which will convert the contents of Cell A1 to upper case (the result will be
in B1)
--
HTH...
Jim Thomlinson
"john d" wrote:
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?
|