Uppercase Formual - Converting Text

[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!!

 

[Paul]

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!!

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

 

[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.

 

[JMay]

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

 

[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.

 

[Don Guillett]

One way

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

 

[David McRitchie]

I would suggest a generic solution where you can run a macro to
change your constants to upper case contents based on the what
cells have content within a selection. IF the range is always
going to be the same you could substitute Range("B1439:B1491").
for selected. see
http://www.mvps.org/dmcritchie/excel/proper.htm#upper