Hi Danielle
You will need to use a simple macro as below
Sub ConvertToProper()
Dim c As Range
For Each c In ActiveSheet.UsedRange
c.Value = WorksheetFunction.Proper(c.Value)
Next
End Sub
Copy the Code above
Alt+F11 to invoke the
VB Editor
InsertModule
Paste code into white pane that appears
Alt+F11 to return to Excel
To use
Select the sheet where the Capitals appear
Alt+F8 to bring up Macros
Highlight the macro name (ConvertToProper)
Run
I hope this helps. If you are still having difficulties, post back
--
Regards
Roger Govier
"DanielleC" wrote in message
...
I'm not very familiar with using anything other than the very basic
formulas
on Excel. I'm using Microsoft Excel 2007 and all I want to do is be able
to
take a spreadsheet that is in all caps and convert it to proper. I've
tried
using the stupid formula... there's hundreds of cells that need to be
formatted. Please help, I'm beyond frustrated. When I google for help its
like people are talking Chinese... and they're saying go to tools or look
for
macros... I see NONE of these things.
For the love of all that is holy...
Help me.
:)