Ms Excel Font Case

[jackhero]

i want to know the shortcut key used for changing the font case in ms excel ? shift+f3 is used for such purpose in ms word but in excel its not working. i have 2007 version of office. it irritates alot when you have typed the (text) data  & in the end you see that the font case is not correct. kindly help me

[soybean]

You have font controls on the Home ribbon.  Why aren't you using them to set your font? 

[Treval]

I hate it when people ask for a specific answer and you suggest something different. rofl
By the way there is no way to change to all upper through the ribbon (unless there are hidden ribbon functions I don't know about)

Anyway:

The short answer is no, but that's also the unhelpful answer - you haven't said what form the data takes, but if it is a database, the quickest way to do it is to select all, copy, then paste into Word - use words format change case menu to fix the problem, then reverse the process to get it back to Excel.  Excel itself doesn't have a title case function, so if this method doesn't work you would need to write a custom function which went through every cell in the workbook (or better, a given range) and carried out the appropriate formatting.  I can write a suitable macro for you if this would help

The simple way to change your text to uppercase or lowercase is to use the respective UPPER("text") and LOWER("text") functions of Excel. e.g. you have a text "hello" in cell A1 and you would like to change this to "HELLO". What you do is you click on the cell A1 and in the formula bar you write: =UPPER("HELLO"). If it's a lot of text then I would just copy/cut the text that is already in the cell and place it between =UPPER("").

That's what I know so far. What would be nice is to write a macro or VBA that reacts to the push of a shortcut key and does just that (LOWER("") and UPPER("") fuctions). One could do this. I don't know how to, yet. If there are any friendly programmers out there =P LOL, please write a neat little VBA script that fulfills this youngman's desires. Thanks!

Treval
 

[soybean]

I hate it when people ask for a specific answer and you suggest something different. rofl

Well, shucks now, my brain just focused on font and competely overlooked the word following it, i.e. case.

What would be nice is to write a macro or VBA that reacts to the push of a shortcut key and does just that (LOWER("") and UPPER("") fuctions).

Here's a macro:

Sub UpperCase()
Dim Cell As Range
For Each Cell In Selection.Cells
If Cell.HasFormula = False Then
Cell = UCase(Cell)
End If
Next
End Sub

It can be applied to a range of cells all at one time.   

[Treval]

Thanks and I hope the OP will be happy with it. =P

[jackhero]

thnkx for your help. Upper & lower case in formula tab is a good idea. thank u verymuch. but there is another thing that how can i get the first letter of every word in selected text/cell in upper case ? again i will give the example of ms word that if you continue pressing shift+f3 then you will see the variation (all upper case, all lower case and first letter upper case). can i bring this thing from ms word in ms excel ? i am totally unaware of creating / using macro. is it possible to do that stuff in excel which is available in ms word ?

[soybean]

Using the PROPER function in a formula such as =PROPER(A2) will do that.

an i bring this thing from ms word in ms excel ?

I think that question is a bit over-simplified but the answer is basically no.  Keep in mind you're comparing a word processing program with a spreadsheet program.  They are designed for different purposes.

[Treval]

You're talking about program design to someone who is barely familiar with software. =P

[soybean]

You're talking about program design to someone who is barely familiar with software. =P

Oh, come on, now.  My reply was not technically complex at all.  What's complicated about:

Keep in mind you're comparing a word processing program with a spreadsheet program.  They are designed for different purposes.

I think that's a point he needs to recognize and I don't know how it can be stated any simpler.

[Treval]

1. He could not know what you mean by 'processing words'
2. idem + 'spreadsheet'
3. idem + 'design of a program'

Here's how I would say it:

Keep in mind that Word and Excel don't do the same. =P

[BC_Programmer]

People aren't stupid. they know what the word "designed" means. It's like.... you don't have to be an architect to know what people mean when they say what a building was designed for.

Anyways, I wanted to post the "propercase" version of Soybeans macro:

Code: [Select]

Sub ProperCase()
Dim Cell As Range
For Each Cell In Selection.Cells
If Cell.HasFormula = False Then
Cell = StrConv(Cell,vbProperCase)
End If
Next
End Sub


[Treval]

No, I actually don't know what you mean by "this building was designed for". A building can have a function? O.o
Aren't all buildings the same? So many million factors..

[BC_Programmer]

No, I actually don't know what you mean by "this building was designed for".

You don't design a department store the same way you design a two bedroom rancher.

[Treval]

I don't know what a rancher is.. =P