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
For my research in medicine I build a spreadsheet with google docs. After having received most of the data I transfered the spreadsheet into an excel file. The next thing I would like to do is to convert the words in the spreadsheet into numbers so I can calculate with them. For example: every row in column E consist of one of the two words: 'man' or 'woman'. I would like to convert the word 'man' into a '0' and the word 'woman' into a '1'. Is it possible to write a formula or function for this?
Note : It works for a value having two decimal places. It truncates if you have a value having more than two decimal places. Note : The following formula can convert amount one less than 1 trillion into words.
For example : $ 1,250.50 = One Thousand Two Hundred Fifty Dollars and Fifty Cents
GLOBAL DESCRIPTION GLOBAL DESCRIPTION1 Particular description1 GLOBAL DESCRIPTION1 Particular description2 GLOBAL DESCRIPTION2 GLOBAL DESCRIPTION2 Particular description1 GLOBAL DESCRIPTION2 Particular description2
I want to to have in the second column:
GLOBAL DESCRIPTION1 Particular description1 Particular description2 GLOBAL DESCRIPTION2 Particular description1 Particular description2
So far I have this: +IF(EXACT(A1;UPPERCASE(A1));A1;+RIGHT(A1;LEN(A1)-(FIND(X;A1;1)-1)))
X standing for the position of the first lowercase, which I don't know how to get.
I am using the following code behind this sheet. In row 9 and column D if I put a lower case letter i want to convert it to uppercase automatically can you see what I am doing wrong.
Private Sub Worksheet_Change(ByVal Target As Range) 'Debug.Print Target.Text & " " & Target.Value & " " & Target.Value2 Dim vVal 'If Target.Cells.Count > 1 Then Exit Sub If Intersect(Target, Range("C9:D28")) Is Nothing _ And Intersect(Target, Range("G9:H28")) Is Nothing _ And Intersect(Target, Range("K9:L28")) Is Nothing _ And Intersect(Target, Range("O9:P28")) Is Nothing _ And Intersect(Target, Range("S9:T28")) Is Nothing _ And Intersect(Target, Range("W9:X28")) Is Nothing _......
I have created a text convertor which will convert any text into upper case or lowercase (not very complex but very handy!) Is there anyway way that when text is in uppercase and I convert it to lower case that it makes every character after a full stop in upper case
Example DAVID WAS NOT WELL. HE WENT HOME to David was not well. He went home
Can we unmerge a complete address in seperate seperate coloumns? Like Complete address is "1st Floor, 2a Harrison Road, Erdington, West Midlands, B24 9AA" and i want to split it like Address "1st Floor" , Address: "2a Harrison Road", Address: "Erdington"...
Is there is any formula which can split data with the help of seperators (Comma or space) ??
EXCEL FORMULA CHALLENGE:Needs a formula like as above , expand the formula to generate from One to Nine Hundred Ninety Nine Thousand Nine Hundred & Ninety Nine? 1 to 999,999,999 all numbers into words between this range ?
I have a column of words in Column A and I want to replace all the times that these words appear in the rest of the excel sheet with the words in Column B. If someone has already answered a similar problem link me to the thread because I can't find anything.