Possible to distinguish uppercase from lowercase text?

[seed]

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.

 

[BT]

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]

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

 

[Bernie Deitrick]

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(xlCellTypeConstants)
myC.Value = UCase(myC.Value)
Next myC

End Sub

 

[Dave O]

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

 

[Gord Dibben]

Wrong assumption.

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


Gord Dibben MS Excel MVP