All upper

[kevs]

Let's say you have many rows and columns in upper and lower case. Does excel
have quick way to select the whole worksheet and make everything uppercase?

OS 10.3.4
Office 2004

 

[Peo Sjoblom]

You would need a macro if you want it quick
I use this

Sub UpCase()
Application.DisplayAlerts = False
Dim R As Range
For Each R In Selection.Cells
If R.HasFormula Then
R.Formula = "=UPPER(" & Mid(R.Formula, 2) & ")"
Else
R.Value = UCase(R.Value)
End If
Next
Application.DisplayAlerts = True
End Sub


open the visual basic editor, insert a module and paste in the above
close the editor and select the text and run the macro

A slower way would be to use a formula and a help column

=UPPER(A1)

as an example, copy down, paste special as values and delete the original
data if necessary

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[kevs]

Wow! Too much for me. Can't Excel just make a button?

You would need a macro if you want it quick
I use this

Sub UpCase()
Application.DisplayAlerts = False
Dim R As Range
For Each R In Selection.Cells
If R.HasFormula Then
R.Formula = "=UPPER(" & Mid(R.Formula, 2) & ")"
Else
R.Value = UCase(R.Value)
End If
Next
Application.DisplayAlerts = True
End Sub


open the visual basic editor, insert a module and paste in the above
close the editor and select the text and run the macro

A slower way would be to use a formula and a help column

=UPPER(A1)

as an example, copy down, paste special as values and delete the original
data if necessary

OS 10.3.4
Office 2004