Ojc
Member
Registered: 14th Nov 00
Location: Reading: Drives : Clio 197
User status: Offline
|
If you have just done a entire spreadsheet in capitals when you should have done it in lower case how do you then change it from capitals to lower case?
Safe
|
MatthewR
Member
Registered: 21st Oct 02
Location: Rickmansworth
User status: Offline
|
Highlight, delete, start again dumbo
|
PaulW
Member
Registered: 26th Jan 03
Location: Atherton, Greater Manchester
User status: Offline
|
just looked thru cant find anything which gives you the option soz
|
Melville
Member
Registered: 4th Jun 03
Location: Newcastle upon Tyne
User status: Offline
|
there isnt anything in excel only word. I might be possible to copy it into word, format>change case then copy back, but I very much doubt it would work
|
PaulW
Member
Registered: 26th Jan 03
Location: Atherton, Greater Manchester
User status: Offline
|
yup, could export as a delimited CSV, import into word, edit, re-save & then import back into excel?
|
Ojc
Member
Registered: 14th Nov 00
Location: Reading: Drives : Clio 197
User status: Offline
|
Jesus christ, I'm doing it for someone else so I'm not gonna bother with all that 
I will just say to her "no" can't be done.
|
MatthewR
Member
Registered: 21st Oct 02
Location: Rickmansworth
User status: Offline
|
|
Gambit
Member
Registered: 5th Jun 00
Location: Common Sense HQ
User status: Offline
|
i take it she aint good looking then
|
Dom
Member
Registered: 13th Sep 03
User status: Offline
|
nope, only way to do it is write a little vb script to sort it...
basically go View > Toolbars > and select Visual Basic
The click on the icon that says "Visual Basic Editior" (new window will open), select the current sheet your working on eg:sheet 1 etc (in the left panel), then in the main white text box Copy/Paste the following code:
code:
Sub ConvertToLowerCase()
Dim Rng As Range
For Each Rng In Selection.Cells
If Rng.HasFormula = False Then
Rng.Value = LCase(Rng.Value)
End If
Next Rng
End Sub
then close that window, go back to your excel sheet, select the cells you wish to convert to lower case, then press the little green play button icon in the visual basic toolbar. It will come up with a macro window, select the macro eg: sheet1.ConvertToLowerCase, and click run 
[Edited on 30-09-2004 by VisibleMan]
|
Dom
Member
Registered: 13th Sep 03
User status: Offline
|
more info can be found >> HERE <<
|
micra_pete
Premium Member
Registered: 23rd Apr 03
Location: West Yorkshire
User status: Offline
|
in word highlight the text hold shift press f3 (just asked admin) excel, fuck knows.
VisibleMan - you talk funny at the bottom or that post, what they hells a If Rng.HasFormula
|
Dom
Member
Registered: 13th Sep 03
User status: Offline
|
quote:
Originally posted by micra_pete
in word highlight the text hold shift press f3 (just asked admin) excel, fuck knows.
VisibleMan - you talk funny at the bottom or that post, what they hells a If Rng.HasFormula
basically, the code goes through every selected cell(s) and if it doesnt have a formula in that cell (If Rng.HasFormula = False) then it converts the current upper case text to lower case (Rng.Value = LCase(Rng.Value) ) 
Its the only way i know how to convert text cases, apart from exporting it, importing into word, export again etc etc
|
Sam
Moderator
Premium Member
Registered: 24th Dec 99
Location: West Midlands
User status: Offline
|
You don't need to use macros, just use the Proper function if you want to convert the text to lowercase but have the first letter in uppercase, or the Lower function, which will make all the text lowercase.
|
