Excel Help

[GilbertsGrape]

I have an excel Document that is in ALL CAPS and I need it to be in Caps and lowercase letters. Or even all lower case would help. Is there a way to convert this?

[eSDee]

Go to Edit->Find and then click on the Replace tab. In the Find field put "A" and then in the Replace field put "a". At the bottom left click on "Replace all". Do this with every letter, and you should be good to go.

[GilbertsGrape]

Originally posted by eSDeeLoco
Go to Edit->Find and then click on the Replace tab. In the Find field put "A" and then in the Replace field put "a". At the bottom left click on "Replace all". Do this with every letter, and you should be good to go.


HA HA HA !!!


I only have about 10,000 Records to do

[eSDee]

Originally posted by GilbertsGrape
I have an excel Document that is in ALL CAPS and I need it to be in Caps and lowercase letters. Or even all lower case would help. Is there a way to convert this?

:shrug: It said document. Replace all will replace all in the document.

[seqiro]

You can do this with a macro. A quick google search came up with the following:

Sub Propercase_macro()
Dim selectie As Range
Dim cel As Range
On Error Resume Next
Set selectie = Range(ActiveCell.Address & "," & Selection.Address) _
.SpecialCells(xlCellTypeConstants, xlTextValues)
If selectie Is Nothing Then Exit Sub
For Each cel In selectie
cel.Value = StrConv(cel.Value, vbProperCase)
Next cel
End Sub


Create that macro, select the whole sheet, and run the macro.

[GilbertsGrape]

Thank you seqiro That worked Great.

[mcs328]

Can you copy the whole bloody thing in MS Word then I think go under Format -> Change Case, choose either all lower case, Sentence case, Title Case, UPPERCASE, or ToGgLe CaSe?

The paste back the whole crapola back into excel?

[eSDee]

You're welcome Gilbert. Oh wait, no you're not ;)

[GilbertsGrape]

Originally posted by eSDeeLoco
You're welcome Gilbert. Oh wait, no you're not ;)


I can see you are one of those trouble makers. ;) :angel: