Setting up results from a database for analysis in Minitab. Minitab thinks
the same string in capital verses lower case letters are two different
things, so I'd like to be able to have a macro change all characters to upper
case. Otherwise I've got to do this by hand, which isn't a huge problem but
it's another of many things that rack up to making a simple task take
seemingly forever.

Seed,

Try the macro below.

HTH,
Bernie
MS Excel MVP

Sub MakeAllUpperCase()
Dim myC As Range

On Error Resume Next
For Each myC In ActiveSheet.UsedRange.SpecialCells(xlCellTypeConst ants)
myC.Value = UCase(myC.Value)
Next myC

End Sub


"seed" wrote in message
...
Setting up results from a database for analysis in Minitab. Minitab
thinks
the same string in capital verses lower case letters are two different
things, so I'd like to be able to have a macro change all characters to
upper
case. Otherwise I've got to do this by hand, which isn't a huge problem
but
it's another of many things that rack up to making a simple task take
seemingly forever.

The UPPER() function changes the string inside the parens to upper
case. For instance, =UPPER("All capital Letters") returns ALL CAPITAL
LETTERS. Will that help you?

Dave O
Eschew obfuscation

Hi there.

Use a blank "helper" colum and enter the formula =Upper(celladdress). Copy
down, then Copy / Paste Special / Values and overwrite existing data.

BT

"seed" wrote:

Setting up results from a database for analysis in Minitab. Minitab thinks
the same string in capital verses lower case letters are two different
things, so I'd like to be able to have a macro change all characters to upper
case. Otherwise I've got to do this by hand, which isn't a huge problem but
it's another of many things that rack up to making a simple task take
seemingly forever.

Well that's pretty durn easy. So easy, in fact, that I'll just assume that
checking the help section in excel wouldn't have given me the answer and that
I didn't in fact waste a few seconds of your time.

Most of the answers I'm looking for involve something more than the help
section - sometimes I forget it's there!

Thanks -

Ryan

"BT" wrote:

Hi there.

Use a blank "helper" colum and enter the formula =Upper(celladdress). Copy
down, then Copy / Paste Special / Values and overwrite existing data.

BT

"seed" wrote:

Setting up results from a database for analysis in Minitab. Minitab thinks
the same string in capital verses lower case letters are two different
things, so I'd like to be able to have a macro change all characters to upper
case. Otherwise I've got to do this by hand, which isn't a huge problem but
it's another of many things that rack up to making a simple task take
seemingly forever.

Wrong assumption.

Help on "upper case" or "change text case" would have given you the answer.


Gord Dibben MS Excel MVP

On Thu, 26 Feb 2009 11:11:02 -0800, seed
wrote:

Well that's pretty durn easy. So easy, in fact, that I'll just assume that
checking the help section in excel wouldn't have given me the answer and that
I didn't in fact waste a few seconds of your time.

Most of the answers I'm looking for involve something more than the help
section - sometimes I forget it's there!

Thanks -

Ryan

"BT" wrote:

Hi there.

Use a blank "helper" colum and enter the formula =Upper(celladdress). Copy
down, then Copy / Paste Special / Values and overwrite existing data.

BT

"seed" wrote:

Setting up results from a database for analysis in Minitab. Minitab thinks
the same string in capital verses lower case letters are two different
things, so I'd like to be able to have a macro change all characters to upper
case. Otherwise I've got to do this by hand, which isn't a huge problem but
it's another of many things that rack up to making a simple task take
seemingly forever.