Thread: Change case
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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?