Uppercase Formual - Converting Text

C

carriecms

Hello! I am in great need of some instruction on how to select a group
of cells and change it from lower case to all upper case. I have tried
the basic help tutorial and have had no success.

I have text in column B rows 1439 to 1491 that need to be converted.

In advance, I appreciate the help!!
 
P

Paul

carriecms said:
Hello! I am in great need of some instruction on how to select a group
of cells and change it from lower case to all upper case. I have tried
the basic help tutorial and have had no success.

I have text in column B rows 1439 to 1491 that need to be converted.

In advance, I appreciate the help!!
Click to expand...

Take a look at the UPPER function. For example:
=UPPER(B1439)
 
C

carriecms

but I've typed =UPPER(B1439) in the field and I get an error. The only
thing that happens after that is that my text disappears and I get a
zero in it's place.

Obviously Excel is not a program that I use regularly.
 
J

JMay

you are of course entering the formula UPPER(B1439) in the cell say C1439,
as an example -- right?
 
I

immanuel

You'll need to type that formula in a cell other than B1439 or you'll get
the circular reference error you got. If column C is free, type it in
C1439.

/i.
 
D

Don Guillett

One way

Sub makeupper()
For Each c In Range("a1:a10")
c.Value = UCase(c)
Next
End Sub
 
Top