Solve : Ms Excel Font Case?

1.	Solve : Ms Excel Font Case?
Answer» 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 meYou have font controls on the Home ribbon. Why aren't you using them to set your font? 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: Quote 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 Quote from: Treval on March 27, 2010, 01:32:06 PM 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. Quote 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. Thanks and I hope the OP will be happy with it. =Pthnkx 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 ?Using the PROPER function in a formula such as =PROPER(A2) will do that. Quote 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. You're TALKING about program design to someone who is barely familiar with software. =PQuote from: Treval on March 28, 2010, 12:34:55 PM 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: Quote from: soybean on March 28, 2010, 12:23:43 PM 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. 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. =PPeople 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 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..Quote from: Treval on March 28, 2010, 09:45:04 PM 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.I don't know what a rancher is.. =P

Answer»

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 meYou have font controls on the Home ribbon. Why aren't you using them to set your font? 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:

Quote

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

Quote from: Treval on March 27, 2010, 01:32:06 PM

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.

Quote

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. Thanks and I hope the OP will be happy with it. =Pthnkx 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 ?Using the PROPER function in a formula such as =PROPER(A2) will do that.

Quote

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. You're TALKING about program design to someone who is barely familiar with software. =PQuote from: Treval on March 28, 2010, 12:34:55 PM

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:
Quote from: soybean on March 28, 2010, 12:23:43 PM

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. 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. =PPeople 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
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..Quote from: Treval on March 28, 2010, 09:45:04 PM

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.I don't know what a rancher is.. =P

Solve : Ms Excel Font Case?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment