Capatilising text

  • Thread starter Thread starter Linz
  • Start date Start date
L

Linz

Is there any way in Excel CAPATILSE all the words in a selection so there're
all changed at once. In lower case at the moment.

Thank to anyone that can help.

Linz
 
Hi,

Right click the sheet tab, view code and paste this in. Select your cells
and run the code:-

Sub capitalise()
Dim myrange As Range
Set myrange = Selection
For Each c In Selection
c.Value = UCase(c.Value)
Next c
End Sub

Mike
 
Linz said:
Is there any way in Excel CAPATILSE all the words in a selection so
there're all changed at once. In lower case at the moment.

Thank to anyone that can help.

Linz
Click to expand...

You could use a formula such as =UPPER(A1), copied across an area as large
as your original area. Then copy the resulting area, select the top left
cell in your original area (such as A1), and use
Paste Special > Values
 
Back
Top