Change lower case to upper case

[Lou_07]

How do I change text in cells from lower case to upper case. Have tried using
a macro but wasn't able to understand the process. I have 2 long columns to
change. Can anyone help please?

 

[Héctor Miguel]

hi, Lou !

How do I change text in cells from lower case to upper case.
Have tried using a macro but wasn't able to understand the process.
I have 2 long columns to change. Can anyone help please?

you might want to give a try to the following:

if available, try to change the font for your range/worksheet/workbook/style/...
(no other tricks/code/stuff/... needed) no matter if user types in lower/upper case...

this fonts shows text un uppercase:
- Castellar
- Engravers MT
- Felix Titling
- Stencil
- Technic (*versalles* type)

this font shows text in lowercase:
- Freshbot
- Poornut
- Pussycat

hth,
hector.

 

[Lou_07]

Hector,
Thank you for trying to assist me. Unfortunately, Excel 2007 don't have
these fonts, so after putting my thinking cap on, I selected the text, copied
and pasted it into a Word document, then changed it to upper case, copied &
pasted it back into Excel....voila!
Thanks again
Louise

 

[Bob Phillips]

So what was the macro that you had, and what happened when you tried to use
it?

 

[Lou_07]

This is what I found in the help section for Office 2007 .
I clicked the start macro - then selected the rows, clicked in a cell close
to the rows and tried to follow the steps below, but didn't really understand
it.
Louise
Sub Uppercase()
' Loop to cycle through each cell in the specified range.
For Each x In Range("A1:A5")
' Change the text in the range to uppercase letters.
x.Value = UCase(x.value)
Next
End Sub

 

[Bob Phillips]

The macro works fine, but it does work on the specific range A1:A5. If you
want it to work on cells that you have selected, use

Sub Uppercase()
' Loop to cycle through each cell in the specified range.
For Each x In Selection
' Change the text in the range to uppercase letters.
x.Value = UCase(x.value)
Next
End Sub

 

[Mike H]

You clearly said 'text' but just in case a formula gets selected, I would use
this line in BP's macro

x.Formula = UCase(x.Formula)

Mike