Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
need to make empty cell to type upper case letters
I have an excel file I want all text that will be typed in the empty
cells should be upper case. So I have the formula in them and when I type "msft" and hit enter it should give me "MSFT" |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
need to make empty cell to type upper case letters
On Oct 4, 3:34 pm, chusu wrote:
I have an excel file I want all text that will be typed in the empty cells should be upper case. So I have the formula in them and when I type "msft" and hit enter it should give me "MSFT" Hi Chusu, Not sure you can do it that way. I'd think any formula you have in the cell will be overwritten and destroyed when you type msft. Alternatively, after doing all the typing you need to, you can run a quick macro that changes all text to uppercase. Use this: Sub upCase() For Each cell In Selection cell.Value = UCase(cell.Value) Next cell End Sub All you need to do is select the range you want converted then run the macro! HTH cheers, t. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
need to make empty cell to type upper case letters
You can do that using UCase() in a Change event macro:
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then 'column A Target.Value = UCase(Target.Value) End If End Sub This example works on column A. Regards, Stefi €˛troy@eXL€¯ ezt Ć*rta: On Oct 4, 3:34 pm, chusu wrote: I have an excel file I want all text that will be typed in the empty cells should be upper case. So I have the formula in them and when I type "msft" and hit enter it should give me "MSFT" Hi Chusu, Not sure you can do it that way. I'd think any formula you have in the cell will be overwritten and destroyed when you type msft. Alternatively, after doing all the typing you need to, you can run a quick macro that changes all text to uppercase. Use this: Sub upCase() For Each cell In Selection cell.Value = UCase(cell.Value) Next cell End Sub All you need to do is select the range you want converted then run the macro! HTH cheers, t. www.eXtreme-eXcel.com ....be indispensable... you'll Double Your Salary! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using COUNTIF and VLOOKUP with upper and lower case letters | Excel Worksheet Functions | |||
How to change lower to upper case letters? | Excel Discussion (Misc queries) | |||
Formatting Upper Case letters | Excel Worksheet Functions | |||
How do I create upper/lower case letters in cells? | Excel Discussion (Misc queries) | |||
Count the occurance of upper or lower case letters | Excel Worksheet Functions |