Change lower case to upper case
 

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?

Change lower case to upper case
 

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.

Change lower case to upper case
 

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

"Héctor Miguel" wrote:

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.

Change lower case to upper case
 

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

--
__________________________________
HTH

Bob

"Lou_07" wrote in message
...
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

"Héctor Miguel" wrote:

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.

Change lower case to upper case
 

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" wrote:

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

--
__________________________________
HTH

Bob

"Lou_07" wrote in message
...
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

"Héctor Miguel" wrote:

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.

Change lower case to upper case
 

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

--
__________________________________
HTH

Bob

"Lou_07" wrote in message
...

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" wrote:

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

--
__________________________________
HTH

Bob

"Lou_07" wrote in message
...
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

"Héctor Miguel" wrote:

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.

Change lower case to upper case
 

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

"Lou_07" wrote:


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" wrote:

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

--
__________________________________
HTH

Bob

"Lou_07" wrote in message
...
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

"Héctor Miguel" wrote:

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.