I am using the code below to convert all input on the spreadsheet to UPPERCASE. This was working fine until I added a Column that contains dates (Column D is formatted like 03/Mar/2009). So when I type in 03-03 in column D I get: 03/Mar/2009 instead of 03/MAR/2009
Can the code be tweaked to accommodate the dates?
Private Sub Worksheet_Change(ByVal Target As Range)
'Converts ALL input to UPPERCASE
Dim cel As Range
Application.EnableEvents = False
On Error Resume Next
For Each cel In Intersect(Target, Target.SpecialCells(xlCellTypeConstants, xlTextValues))
cel.Value2 = UCase(cel.Value2)
Next cel
I am trying to accomplish the following, when i enter a word in column C but in the odd row i want a macro to automatically convert that word to uppercase.
Is there a way to format some particular colums so that when i enter my data into the cells i do not have to keep changing the caps lock to uppercase or pressing shift key which slow down my typing as i am not very fast typer.
My question is about determining whether or not a particular letter is uppercase.
I've written code that reads from a text file one character at a time. And I know that the following determines if each character is equal to the letter "a".
I am trying to change string values of a name from uppercase to lowercase. The data is layed out as lastname then first name. As an example, I have the following values in column C:
ANDERSON MICHAEL SMITH SUSAN P JOHNSON PATRICK JORDAN MICHAEL R WOODS TIGER CLINTON WILLIAM J
I am trying to convert to following (with "," between lastname & firstname):
Anderson, Michael Smith, Susan P Johnson, Patrick Jordan, Michael R Woods, Tiger Clinton, William J
I have a start of how I think the code should flow but can't figure out how to do the conversion.
how to make upper case after mark "." (dot), see this below :
sample data after formula Tabrani,Ny.yusmaniar Tabrani,Ny.Yusmaniar Badu Zai,Tn.surjaah R & Darussamin Badu Zai,Tn.Surjaah R & Darussamin Zainal Arifin,Ny.elvyati Zainal Arifin,Ny.Elvyati etc..
it's possible with excel code? if could perhaps not macro.
i have a form that i have 2 fields that need to be capatalized at all times - B6 and G6 I have used this formula to get B6 to work but for the life of me i cant get BOTH to work and the same time.
here is the formula
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Set Target = Range("B6") 'change to your range If Not IsEmpty(Target) Then Target = UCase(Target.Text) End If End Sub
This is wrekcing my head as I'm sure it can be done with an Array formula and I cant seem to get it sorted -
Say I have 5 Rows of text starting in A2 "A quick word" "A quick WORD" "A" "word" "WORD"
I need an excel formula to say "False", "False", "False", "False", "TRUE".
All conditions to be met for TRUE are - Word must in uppercase, Uppercase Word must be longer than 1 character, Sentence (i.e. cell) can not contain a space. This is the path I've gone down, but almost certainly incorrect -
I am trying to make a column of names appear in upper case (the first letter). I know about Upper(). I cant put that formula in this column because the names are typed there, (it would erase formula). How can I do this as well as have them alphabetically ordered?
I import a CSV file into Excel where the column title row has column titles that are just one long text string, without any spacing between the words. For example: CompanySiteDescription CompanySiteExternalSystemID IssueNumber
I would like a method (formula or macro) that would add a space-character before each uppercase letter (that's not the first letter in the string or an uppercase letter that directly follows another upper case letter). Thus: CompanySiteDescription becomes Company Site Description CompanySiteExternalSystemID becomes Company Site External System ID IssueNumber becomes Issue Number
To ensure correct data entry, I need to ensure that the filled cells in a column are always in Uppercase for example, irrespective of whether they are typed in upper or lower case.
I have found the following code, which seems to work quite well, even though I have the impression that it slowed my workbook down slightly.
I was using this code in a sheet that contained combo boxes and it worked great. When I redone the sheet a used data validation instead of CB it wold error out.
Code: Sub savee() Range("A4:J22").Select For Each Cell In Selection If Not Cell.HasFormula Then Cell.Value = UCase(Cell.Value) End If Next Cell Range("h4").Select ActiveWorkbook.Save End Sub
I would like a data validation list to only accept an uppercase Y or N from the dropdown in a cell, but users can type a lowercase Ys and Ns and they are accepted. I would like the cell to only accept the uppercase Ys and Ns from the dropdown. Does this require code or is there a simpler way?
Is there a way to get Excel to automatically change the first letter of single word entry to lowercase in each cell of the first row of my worksheet leaving the case the same for all other letters?
I have a list generator that creates a set of data in a multi-column & row dataset. I would like a formula to create a list of the alpha data points only which excludes blanks and any errors.