Possible to distinguish uppercase from lowercase text?

  • Thread starter Thread starter seed
  • Start date Start date
S

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.
 
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
 
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
 
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
 
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
 
Wrong assumption.

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


Gord Dibben MS Excel MVP
 
Back
Top