Column format

[rob]

Hi there ...

I am wondering if Excel 2000 has a similar feature as Word
2000 that allows text case to be formatted in a number of
ways (UPPER, lower, Title Case)

In particular, I want to be able to force the contents of
an entire column to be UPPERCASE, either after the entries
have been made or as they are being made. Is this a
possibility?

TIA

rob

 

[Peo Sjoblom]

http://www.mvps.org/dmcritchie/excel/proper.htm

Scroll down until you come to the UPPER section,
there is nothing built in like in Word but you can do it with VBA (see link)



--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Mark Wielgus]

All three formats are supported in excel. To do this
from VBA, here's a Proper or Title case example:

1. Press alt and F11 to open the code window
2. Double click the sheet name you want to automatically
change case
3. put this code in the code window

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Application.EnableEvents = False
If Target.Column = 5 Then
Target = StrConv(Target, vbProperCase)
End If
Application.EnableEvents = True
End Sub

For uppercase you can change
StrConv(Target, vbProperCase)
to
Ucase(Target)

For lowercase you can change
StrConv(Target, vbProperCase)
to
Lcase(Target)

The 5 is the column you want this validation.

From a spreadhsheet you might be able to work something
out of this.. type any of these in cell B2 and then type
in B1

=UPPER(A1)
=LOWER(A1)
=PROPER(A1)

Mark Wielgus
www.AutomateExcel.com

 

[CLR]

Assuming your lower case (or mixed) data is in column A, put this in cell
B1 and copy down.

=UPPER(A1)

Then you can Copy > Paste special > Values for the entire column B to
eliminate the formulas, then delete old column A if you wish.

Vaya con Dios,
Chuck, CABGx3