How do I upshift text
 

I want to have a series of cells that, when I enter text, it is upshifted

upshifted???

--
Don Guillett
SalesAid Software

"IJO" wrote in message
...
I want to have a series of cells that, when I enter text, it is upshifted

Select your range, FormatCellsAlignmentVerticalTop

Carlos

"IJO" wrote in message
...
I want to have a series of cells that, when I enter text, it is upshifted

upshift = uppercase ??

http://www.cpearson.com/excel/case.htm

Cheers
Andy

IJO wrote:
I want to have a series of cells that, when I enter text, it is upshifted

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Assuming the Range is A1:A20 then

Right Click the Sheet Tab and select "View Code"

Paste the following into the code window

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim MyCell As Range, MyRange As Range
Set MyRange = Me.Range("A1:A20")
For Each MyCell In MyRange
MyCell = UCase(MyCell)
Next
End Sub

Select File ....Close and return to Excel


"IJO" wrote:

I want to have a series of cells that, when I enter text, it is upshifted

Lots of different answers. Each is correct depending on the interpretation
of the question.
Can we hear from the OP? What was the question?

"IJO" wrote in message
...
I want to have a series of cells that, when I enter text, it is upshifted

Upshift.....Superscript??

Gord Dibben Excel MVP

On Thu, 9 Dec 2004 13:26:38 -0500, "CarlosAntenna" wrote:

Lots of different answers. Each is correct depending on the interpretation
of the question.
Can we hear from the OP? What was the question?

"IJO" wrote in message
...
I want to have a series of cells that, when I enter text, it is upshifted