Convert Lower Letter To Capital Letter Automatically
Mar 2, 2009
When I type a single lower case letter into a cell, what formula or conditional formatting should I use to always convert it to a capital letter automatically?
View 9 Replies
Jun 27, 2014
I am trying to set up a worksheet that shows shifts using a Capital "D" and a lower case "d" (one is for a 12 hour shift, the other for only 6 hours). Is there any way to set up a Countif formula that makes the distinction?
View 12 Replies
Nov 17, 2009
Convert the first letter of a string to a capital without altering the rest of the strings format.
example: the activecell contains the string a1st (lowercase a, superscript 1st) how can i achieve this in VBA? Additionally, is it also possible to convert all of a string to capitals except the superscript characters View 9 Replies
Nov 1, 2009
I require a formula which finds the he first capital letter within a cell and returns the text, but I need it to ignore blank cells and the symbol *.
View 6 Replies
Dec 29, 2011
I was wondering whether it is possible to find a formula in Excel that would extract (using RIGHT formula) surname from Name Surname cell despite surname lenght i.e.:
'John Smith' in one cell would give 'Smith' in the other 'Tom Let' in one cell would give 'Let' in the other I have tried to combine RIGHT, FIND and PROPER (for upper case) in one formula but it does not work. View 2 Replies
May 10, 2014
I have many lines of text and I wondered if there is a formula so I can insert a comma before the first capital letter of each line? A small amount of text is below
leave on left Salter Road right Brunel Road What i would like is there to be a comma before the first capital letter so it reads leave on left, Salter Road right, Brunel Road Is this even possible? View 14 Replies
Jan 24, 2014
I have code that I just noticed will not work if user inputs a capital S. I have tried a few things but I can not seem to get it to work. Here was the original code:
If Range("H13") "s" Then I tired this: If Range("H13") "s" or "S" Then View 3 Replies
Jan 3, 2008
Is there any way of writing a macro so that specific cells are formatted to start with a capital letter and end with a full stop. Can you also write a macro to automatically spell check specific cells?
View 11 Replies
Oct 8, 2009
I would like to sort words or data which has the First capital letter, words which has spaces and words which contains number... i have attached a sample file.
View 9 Replies
Dec 31, 2009
For the below formula is it possible to replace the B's (column location) with a cell Say Z146 which contains the letter B (or a number if thats easier and someone can tell me the numbers for each column).
When the formula is dragged into the next cell (down) it takes its column reference from Z147 and then my life becomes so much easier. =IF(INDEX('Overs-Unders'!B:B,MATCH($C145,'Overs-Unders'!$A:$A,0))"",INDEX('Overs-Unders'!B:B,MATCH($C145,'Overs-Unders'!$A:$A,0)),"") View 9 Replies
Mar 7, 2014
I need to change a few hundred cells (one column) where the first letter may be a capital letter to a lowercase letter.
So: GetAwardfromBid to getAwardFromBid or SmallLertter to smallLetter View 3 Replies
Jul 23, 2009
Is there simple function that anyone knows of (or has written) that will convert a letter to its alpha-numeric equivalent?
For instance, A = 1, B = 2, AA = 27, etc (a = 1, b = 2, aa = 27) View 6 Replies
Nov 22, 2005
I need to convert a column letter to a column number for the following line of code in my VBA application:
VB: strAverageBaseFormula = "=AVERAGE(D" & Trim(Str(lngFirstRowOfIncrement + 1)) & ":K" & Trim(Str(lngFirstRowOfIncrement + 1)) & ")" I am inserting a formula into a cell using VBA, but the problem is that I don't know the letter value of column "K" (used in the middle of the line); instead, I know it as column number 11. Is there a simple way to convert the column number 11 to the column letter "K"? View 9 Replies
Jan 20, 2009
How Do I Convert Date:
10/3/2008 into October 6/1/2008 into June 7/3/2008 into July I have date 10/3/2008 in cell and if I convert format to M into Just gives me first letter of Month, so O, I want it to read October, etc. View 2 Replies
Nov 13, 2006
Some bits of code I have learned use column numbers and some bits use column letters.
Can someone share a line or two that I could add to my macro that will convert the F representing column F into a 6, and vice versa, so that I can continue using my pre-existing bits? View 9 Replies
Jan 17, 2004
I can obtain the columns numbers but I cannot get the letters. Is there anyway to convert from a number to a letter?
eg. somefunction(1) gives me column(A) as an answer? View 9 Replies
Jun 21, 2007
a formula that would take letter grades (A, B, C, D, and E) and produce an average letter grade?
For example, a student gets a D on one assignment and a B on another. I want a formula that will produce "C". View 3 Replies
Sep 15, 2014
I wanted to know if there was a way to either make a variable hold a column letter or else automatically convert a column number to a letter. This would be for use in the Range property.
All I could find is some complicated technique requiring division by 26 that I will never remember let alone code quickly. Or if you have a variable holding a column number, is the only way to use it with Cells? View 5 Replies
Sep 4, 2013
I have a drop down menu using data validation and the values are B,C,D
I want to keep the letter in a cell, but make each one become number, so B=5, C=10, D=20 I have another dropo down menu that contains 6,10,16 What I require is that once the 2 drop down menus have 'values selected' I need to multiply the 2 cells together so for example If B and 6 was selected, I require the 3rd cell to be 5*6 so what is the formula? View 1 Replies
Mar 15, 2007
I have a master spreadsheet that I hold data relating to an event, the spreadsheet lists various companies names and contact details that I will need to the event and also what function they will provide by yes/no boxes. the data is currently spread all over the spreadsheet but I suppose it could be linked into some sort of simple table.
I then have to email or telex all the companies and request their assistance. Can excel automate this task? I know it can write an individual letter but could it write one message to all requesting exactly what I need that I could cut and paster to the application I would use to transmit the request? Also when the list of Companies ends can the message move onto the next part.ie if there was a list of 4 Companies to use the message would start "Attn: Co1 / Co2 / Co3 / Co4" but if there was only 2 I would want "Attn: Co1 / Co2" only I currently get "Attn: Co1 / Co2 / /" For example if the "catering" column and "water" column has "yes" but the "marquee" column has "no" as a check could it write "Please provide catering and water" BUT if all three columns were "yes" could it make it "Please provide catering, water and marquee" ? View 2 Replies
Jul 7, 2009
Is there an easy way (without writing my own conversion function) to get the column letter from a range object, as opposed to the column number?
View 5 Replies
Feb 16, 2008
I use currency data pasted from legacy program that pastes dollar values followed by a C or D to represent debit and credits, ie -- 1,000,000.00C or 1,000,000.00D.
Is there some way to remove the letter and correctly format the value to a negative or positive number on a whole worksheet or column? Currently I am doing this manually one cell at a time. View 6 Replies
Jul 11, 2009
I want to apply Data Validation to a cell, so that only the following combination of letters and numbers can be entered.
Letter Letter Number Number Number Number Number Number Letter. e.g AB123456C. View 14 Replies
Nov 20, 2009
in a macro i have this: col=cell.column 'suppose col=16384. then i need to place in a cell this formula =(XFD2708*100/XFD2597)-100 so i'm looking for "something" that can convert 16384 in XFD.
View 2 Replies
Jul 23, 2009
I would like to ask if this is possible, I attached the sample and the problem is there for better understanding of what i want to achieve.
View 14 Replies
Mar 30, 2009
I like the proper formula and find it handy, however do you know if there is a formula that would only keep the first letter in the cell at caps and reduce the rest to lower case, ie
A1 = MY DOG IS WHITE proper(A1) = My Dog Is White what I want is only first letter caps = My dog is white. I'va had a decent look around but can't find anything that would do this? View 4 Replies
Nov 5, 2009
if it possible to produce a letter in excel like you would in word by mail merging.
i dont want to open word as i dont have it on my work pc. im wondering if it possible to do something like this dear ( sheet 1 cell 1 ) thank you for your order of ( sheet 1 cell 2 ) we wish to deliver to you on ( sheet 1 cell 3 ) View 9 Replies
Dec 3, 2008
i want to replace the letter A,B,C,D,E, with numbers from 1-5. When I take of the """" and replace the letter with the numbers the formula does not work. View 6 Replies
Apr 30, 2014
What formula would i use to extract the first letter from a persons name - John Paul Smith = JPS
View 7 Replies
Dec 22, 2006
In the Range "C5:C20" if the user types in S in one of the Cells, I would like the Cell Selection to move three Rows to the right. In other words ActiveCell.Offset(0,3), I need to put this in the WorkSheet Change Code.
View 9 Replies