Changing case of text in a column
 

I'm trying to change the case of text in a column. The Excel Help tells me
to add a formula of =PROPER. I've tried this, but it is not working. The
help guide is not making this clear to me. I have tried to add this formula
to the top cell in the column and drag it down through the cells. I've tried
a few other things, but to no avail. Can anyone offer me any clues?
--
Ronnie

Changing case of text in a column
 

Proper capitalises the first letter and any subsequent letter that doesn't
follow a letter. What you want is Upper.

for example =upper(A1) capitalises the whole text string in A1
Mike

"Ronnie" wrote:

I'm trying to change the case of text in a column. The Excel Help tells me
to add a formula of =PROPER. I've tried this, but it is not working. The
help guide is not making this clear to me. I have tried to add this formula
to the top cell in the column and drag it down through the cells. I've tried
a few other things, but to no avail. Can anyone offer me any clues?
--
Ronnie

Changing case of text in a column
 

I do want PROPER (title Case). I am changing from Upper Case. When i type
the formula in the cell, it deletes my text and leaves: =PROPER(A2)
--
Ronnie


"Mike" wrote:

Proper capitalises the first letter and any subsequent letter that doesn't
follow a letter. What you want is Upper.

for example =upper(A1) capitalises the whole text string in A1
Mike

"Ronnie" wrote:

I'm trying to change the case of text in a column. The Excel Help tells me
to add a formula of =PROPER. I've tried this, but it is not working. The
help guide is not making this clear to me. I have tried to add this formula
to the top cell in the column and drag it down through the cells. I've tried
a few other things, but to no avail. Can anyone offer me any clues?
--
Ronnie

Changing case of text in a column
 

The formula should be typed in an adjacent column and copied down. Then,
Copy PasteSpecial Values on that column to get rid of the formulas, and
then delete the original column if desired.

Vaya con Dios,
Chuck, CABGx3



"Ronnie" wrote:

I do want PROPER (title Case). I am changing from Upper Case. When i type
the formula in the cell, it deletes my text and leaves: =PROPER(A2)
--
Ronnie


"Mike" wrote:

Proper capitalises the first letter and any subsequent letter that doesn't
follow a letter. What you want is Upper.

for example =upper(A1) capitalises the whole text string in A1
Mike

"Ronnie" wrote:

I'm trying to change the case of text in a column. The Excel Help tells me
to add a formula of =PROPER. I've tried this, but it is not working. The
help guide is not making this clear to me. I have tried to add this formula
to the top cell in the column and drag it down through the cells. I've tried
a few other things, but to no avail. Can anyone offer me any clues?
--
Ronnie

Changing case of text in a column
 

Ronnie

The =PROPER(cellref) formula cannot be entered in the same cells/column as the
original text.

Enter it in a helper column and copy down.


Gord Dibben MS Excel MVP

On Tue, 16 Jan 2007 07:51:00 -0800, Ronnie
wrote:

I'm trying to change the case of text in a column. The Excel Help tells me
to add a formula of =PROPER. I've tried this, but it is not working. The
help guide is not making this clear to me. I have tried to add this formula
to the top cell in the column and drag it down through the cells. I've tried
a few other things, but to no avail. Can anyone offer me any clues?

Changing case of text in a column
 

Thank you very much! It worked! I really appreciate it!
--
Ronnie


"CLR" wrote:

The formula should be typed in an adjacent column and copied down. Then,
Copy PasteSpecial Values on that column to get rid of the formulas, and
then delete the original column if desired.

Vaya con Dios,
Chuck, CABGx3



"Ronnie" wrote:

I do want PROPER (title Case). I am changing from Upper Case. When i type
the formula in the cell, it deletes my text and leaves: =PROPER(A2)
--
Ronnie


"Mike" wrote:

Proper capitalises the first letter and any subsequent letter that doesn't
follow a letter. What you want is Upper.

for example =upper(A1) capitalises the whole text string in A1
Mike

"Ronnie" wrote:

I'm trying to change the case of text in a column. The Excel Help tells me
to add a formula of =PROPER. I've tried this, but it is not working. The
help guide is not making this clear to me. I have tried to add this formula
to the top cell in the column and drag it down through the cells. I've tried
a few other things, but to no avail. Can anyone offer me any clues?
--
Ronnie

Changing case of text in a column
 

You're quite welcome............thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3




"Ronnie" wrote:

Thank you very much! It worked! I really appreciate it!
--
Ronnie


"CLR" wrote:

The formula should be typed in an adjacent column and copied down. Then,
Copy PasteSpecial Values on that column to get rid of the formulas, and
then delete the original column if desired.

Vaya con Dios,
Chuck, CABGx3



"Ronnie" wrote:

I do want PROPER (title Case). I am changing from Upper Case. When i type
the formula in the cell, it deletes my text and leaves: =PROPER(A2)
--
Ronnie


"Mike" wrote:

Proper capitalises the first letter and any subsequent letter that doesn't
follow a letter. What you want is Upper.

for example =upper(A1) capitalises the whole text string in A1
Mike

"Ronnie" wrote:

I'm trying to change the case of text in a column. The Excel Help tells me
to add a formula of =PROPER. I've tried this, but it is not working. The
help guide is not making this clear to me. I have tried to add this formula
to the top cell in the column and drag it down through the cells. I've tried
a few other things, but to no avail. Can anyone offer me any clues?
--
Ronnie

Changing case of text in a column
 

If it's showing the formula, rather than the result, then it looks as if the
cell with the formula is formatted as text. Change the format of the cell
to General. You may then need to re-enter the formula, or delete the = sign
and then reinsert it.

When you say "it deletes my text", it sounds as if you've been trying to put
the formula in the same cell where the text was, which of course won't work.
If your original text was in A2, put the formula in a blank cell, for
example B2. When you've done the conversion, if you then want to get rid
of the original column A you can copy column B and Paste Special/ Values
over the top of column A, and then delete column B.
--
David Biddulph

"Ronnie" wrote in message
...
I do want PROPER (title Case). I am changing from Upper Case. When i type
the formula in the cell, it deletes my text and leaves: =PROPER(A2)
--
Ronnie


"Mike" wrote:

Proper capitalises the first letter and any subsequent letter that
doesn't
follow a letter. What you want is Upper.

for example =upper(A1) capitalises the whole text string in A1
Mike

"Ronnie" wrote:

I'm trying to change the case of text in a column. The Excel Help
tells me
to add a formula of =PROPER. I've tried this, but it is not working.
The
help guide is not making this clear to me. I have tried to add this
formula
to the top cell in the column and drag it down through the cells. I've
tried
a few other things, but to no avail. Can anyone offer me any clues?
--
Ronnie

Changing case of text in a column
 

Copy the following macro:

Sub Change_Case()
Dim ocell As Range
Dim Ans As String
Ans = Application.InputBox("Type in Letter" & vbCr & _
"(L)owercase, (U)ppercase, (S)entence, (T)itles ")
If Ans = "" Then Exit Sub
For Each ocell In Selection.SpecialCells(xlCellTypeConstants, 2)
Select Case UCase(Ans)
Case "L": ocell = LCase(ocell.Text)
Case "U": ocell = UCase(ocell.Text)
Case "S": ocell = UCase(Left(ocell.Text, 1)) & _
LCase(Right(ocell.Text, Len(ocell.Text) - 1))
Case "T": ocell = Application.WorksheetFunction.Proper(ocell.Text)
End Select
Next

End Sub


"Ronnie" wrote:

I'm trying to change the case of text in a column. The Excel Help tells me
to add a formula of =PROPER. I've tried this, but it is not working. The
help guide is not making this clear to me. I have tried to add this formula
to the top cell in the column and drag it down through the cells. I've tried
a few other things, but to no avail. Can anyone offer me any clues?
--
Ronnie