Capatilising text

[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

 

[Guest]

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

 

[Stephen]

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

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

 

[Linz]

Thanks all. Both those suggestions worked great.

Linz