upper

I found the following code to automatically change lower case in specified cells to upper case. It does work, however if I clear more than one cell at a time I get an error "Run-time error '13': Type mismatch." In addition to the error message, after debugging, the code doesn't work anymore...

Hello all, I am trying to identify if the last character of the bin location is upper or lower case. I would like to see the answer in column C. Can anyone shed some light on how to do this? Any help would be greatly appreciated <tbody> A B C 1 ITEM BIN LOCATION UPPER/LOWER 2 WIDGET1...

Sorry, but I can find a place to ask a MRExcel site question, so here it is. When I used to sign in I had a home page that had my user name, it would say Welcome SeniorTom and a way to sign out. From there I would go to the forums. In the upper left was the MRexcel logo and the logout and...

Hello everyone, I have a challenge for you :) In the table below, I would like to have a formula (going from D5 to D19) which is giving me the closest upper "Total Hours" value when the C column is in state "TRUE". Some formulas were tried, but it was always giving me B17 results instead of...

Hi I've modified my formula or at least tried to because I want only upper case letters to be inputted for the data. My data format is as follows 1234AB12345 where AB must be capital. I've tried using the upper function in my formula but it still allows for lower case letters. I've been stuck on...

I am working in a macro and for the sake of speed would like to use the Excel UPPER() function instead of VBA's UCase(). I am failing to find it among the Excel objects. I thought it might be part of WorksheetFunction, but that is not the case. Is it useable from VBA?

Hello, I need to count the word "upper" in two ranges, whether "upper" appears in column L or in column n, or both. I need to know the unique number of "uppers" for 2300+ records. L2:l2335 and n2:n2335 EX: L column N column COMMENTARY record 1 upper upper This would count as 1 record 2...

I want to cell value in A1 be UPPER but i dont want to use something like this Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Or Target.HasFormula Then Exit Sub On Error Resume Next If Not Intersect(Target, Range("A1")) Is Nothing Then...

Hello excel enthusiasts, I'm sure there is a way to do it, but I can't figure out the simplest way short of a really long really nested if function. I have a list (900 lines long) and then I have another list which corresponds to scores. Here is an example: 100 - A 90 - B 80 - C 70 - D 60...