Excel

[Amanda]

Need know if i can capitalize text in Excel as you can in
word and how ???

 

[Norman Harker]

Hi Amanda!

Try Google Searching. I searched on Convert to Upper Case and...

Peo Sjoblom answered this same question:

Quote>>

Word has that built in, under format>Change Case,
maybe that is what you were thinking of? Excel does not have that
built in,
you either have to use
a help column and a formula

=UPPER(A2)

copy down, copy and paste special as values over the old values,
delete help
column

or you could run a macro like the one below

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


press Alt + F11, click insert module and paste in the above,
press At + Q to close the VBE, select the text and press Alt + F8 to
run the
macro

<< End Quote

Best way to Google search on Excel questions is to use Ron de Bruin's
Google Search 6.0:

http://www.rondebruin.nl/Google.htm

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Peo Sjoblom]

No, not like in word. You can use a help column/row and a formula

=UPPER(A1)

copy down and then paste special as values over the old or you can run a
macro

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


you would press alt +F11 and then insert>module and paste the above,
then select the text and press alt +F8 and run the macro

 

[Norman Harker]

Hi Peo!

Word for word what you said on Dec 7. What a coincidence!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.