=upper("venkat") returns VENKAT =upper(a1) returns the text in A1 in upper case
similary lower proper will turn the first letter into uppercase
is this what you want;.
Terry <email@example.com> wrote in message news:firstname.lastname@example.org... > Win XP Pro > Office 2003 > > Using "Excel" and wish to select any text in a worksheet to ALTER the case > to either upper or lower. > When using "Word" it is easy via the menu. > Is there a menu driven option in Excel of using a function for this purpose.
I would like to format a row of cells so that when a word is entered into the cell it automatically becomes a capital.
I need the word to be capitalized so that I can use it in a custom function. The function uses the word from this cell and goes through a bunch of cases in determing how to classify the string.
I think more than one solution is possible and I would greatly appreciate some feed back, I've tried looking into turning all the letters of a string in my VBA code to capitals, or a way to format the cells, so that the string is already capitalized when entered into the VBA code, but I'm still a novice at VBA and unsure on how certain commands work.
here is a sample of my vba code.
Function WeightI(Shape As String, sDim As String, dLenFt As Double) As Double Const pi As Double = 3.14159265358979 Const Ft2In As Double = 12 Const dDen As Double = 0.2835 ' density of steel, pounds per cubic inch
For Each cel In Range("E6:AI15").Cells If IsError(cel.Value) Then Else Select Case UCase(cel.Value) Case "H" cel.Font.ColorIndex = 0 cel.Interior.ColorIndex = 3 Case "S" cel.Font.ColorIndex = 0 cel.Interior.ColorIndex = 10
but I want the cells to accept both upper and lower case values and format the cells accordingly ie. H or h, S or s
I am using the Find fuction to look for values in cells that contain text in both lower and upper case. I am comparing the values that I have stored in a lookup table. I am running into trouble when the lookup table doesn't match the text cells....
I am trying to detete rows that have several specific values, upper and lower case, (A-H) in any of several columns (B through H). I can delete upper and lower case "D"s in column B, but I'm having difficulty stringing together several variations and getting at the "D"s that are midstream (such as: ADeC), I tried ("*D*") to no avail.
With . Cells(Lrow, "B") If Not IsError(.Value) Then '**** If LCase(.Value) = LCase("D") Then .EntireRow.Delete
Is it possible to change and entire sheet to Upper case using the 'Upper' function?
We are need to change all the text to caps but can only seem to apply the function to one cell at a time and then copy it down for the column. This is going to be a fairly labour intensive process as we have many columns.
I'm using Excel 2010. When I type 'true' or 'false' in any cell, Excel automatically changes to CAPITAL and Align Centre. I have to use the function 'lower' to change to lower case and manually to align to the left.
The values in F4:F14 are changed depending on the value in F2. The rows in green have a fixed value. The row in yellow has a lower limit (170)and upper limit (195). I cannot get a formula in F14 to perform this function.
I want to generate random times in excel between upper and lower limits , which i can do , but i also want dates in same cells with out randomization , means dates should act independently and time should randomize
it should be something like that
8/1/2013 05:55 AM 8/2/2013 07:55 AM 8/3/2013 04:44 AM
I have a table that I use to generate about 20 graphs. The lower and upper limits can be manually altered in the table. If the user leave those 2 cells empty, I want the upper and lower limits be determined by default by Excel. So that the limits don't have to be entered for every graph in order for the graphs to be generated without any debugging error.
In column J of my Excel 2003 worksheet named: Sheet1, is a list of mailing addresses. A copy of the spreadsheet is attached. I need a macro to please capitalise (Upper-case) the second character only of all the Post Office addresses.
Po Box 65, ORLANDO, NSW 2697
All of my Post Office addresses are prefixed: Po
I need the Post Office addresses to be prefixed: PO
So, the above mentioned example should look like this: PO Box 65, ORLANDO, NSW 2697