Excel Capitalization

[sgtbob]

I do not seem to be able to change alpha data already entered into
spreadsheet from 'lower' case to 'UPPER' case via using the formula.
The help files are not helping! Can anyone show a step by step proces
to chage 'david' in cell 'c3' to 'DAVID' in the same cell? Or t
change ALL lower case to UPPER case in a SS? This should be
relatively easy process, but I can't seem to follow the instruction
given in the hlep files to get from 'david' to 'DAVID'.

Bo

 

[Frank Kabel]

Hi Bob

with the UPEER function you cannot change the text in the SAME cell.
You have to use a helper column. So in your example use column D. In D1
insert
=UPPER(C1)
copy this formula for all rows
Now copy column D and insert the contents with 'Insert - Paste Special'
as values in column C. Delete helper column D

Frank

 

[Paul]

I think that should have been
Edit > Paste Special > Values
rather than Insert .....

 

[Ron de Bruin]

Hi Bob

You need a macro to change the text to upper in the same cell
Here is a Macro for changing text cells in the selection

Sub Uppercase_macro()
Dim selectie As Range
Dim cel As Range
On Error Resume Next
Set selectie = Range(ActiveCell.Address & "," & Selection.Address) _
.SpecialCells(xlCellTypeConstants, xlTextValues)
If selectie Is Nothing Then Exit Sub
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
For Each cel In selectie
cel.Value = UCase(cel.Value)
Next cel
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
End Sub

See this webpages

http://www.mvps.org/dmcritchie/excel/proper.htm
Or
http://www.cpearson.com/excel/case.htm

 

[sgtbob]

Many thanks to those responding to my question. I've tried the first
suggestion and it works with some manipulation. I'll try the macro
suggested.

I really appreciate the help, I've been trying to change lower to UPPER
case for a long time and never could figure it out.

Bob

 

[Frank Kabel]

Hi Paul,

you're (of course) right
Frank

I think that should have been
Edit > Paste Special > Values
rather than Insert .....