Is it possible to convert to lowercase all words unless a word has two or more consecutive capitals or two or more consecutive capitals followed by fullstop?
I.e.
This Is a Test (TIT)
This Is a Test (T.I.T.)
Αυτό Είναι Δοκιμή (ΑΕΔ)
Αυτό Είναι Δοκιμή (Α.Ε.Δ.)
should become
this is a test (TIT)
this is a test (T.I.T.)
αυτό είναι δοκιμή (ΑΕΔ)
αυτό είναι δοκιμή (Α.Ε.Δ.)
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 _......
Is it possible to have this type of case sensitive sorting (first all words beginning with a capital later and then all cells beginning with a lowercase letter):
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
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 am looking for a conditional formula that can be applied to a cell so that when I enter a number with a positive value, it:
1) Converts it to its negative equivalent value. 2) Displays in the value in the cell with parentheses around the number to indicate that the value is negative.
I am trying to do this without having to reference another cell to provide the entry or display the outcome.
Any VBA that I can put into a macro that will convert conditional formatting into fixed formatting..? So when the cell contents/formulas are deleted the formatting remains. Assume that the range I want to convert is A1:D200...
Is it possible to change the format of cell AI3 based on the format of cell C3 and D3? I have C3 and D3 set to turn red based on what is in cell C2 and D2. I would like the following done:
If AI3=C3 & C3 is red, format AI3 blue If AI3=D3 & D3 is red, format AI3 blue Otherwise, leave AI3 unformatted.
I need to run a loop through a column of values (attachment col B) and when it finds a "J" it will apply conditional formatting to a row of 4 cells directly adjacent. The attachment is a theoretical before & after.
I have a list containing blocks of stock price values with each block representing a series of values at a given time e.g
1400 156 1400 99 1400 74 1400 86 1400 256
The number of entries may vary for each block but is never more than 60. the next block may be e.g.
14:05 15 14:05 42 etc
and down a very long list of around 65000 entries. I'm looking for a routine that will add up all the values in each block and calculate the total for that time block. I then need to fill in an adjacent column with the perecentage that each value is of the total. A completed block may look like;..............
I've taken on an old excel datasource any I need to restructure it and a column is foxing me.
The column lists time in mm.ss format (decimal seperator), so 1.5 hours is shown as 90.00. For future use, I need this column to be formatted in hh:mm:ss (colon sepertors), ie 1:30:00
I am trying to save a file from xls to csv. One of my columns in the xls file is filled with numbers separated by commas but is saves as a text. Whenever I save the file as a csv it converts the numbers saved as a text to be saved as numbers so it screws my commas up and therefor messes up the entire file.
I am using the function =LOOKUP(J2,Sheet4!$A$2:$A$1000,Sheet4!$B$2:$B$1000) which sometimes returns a #N/A error. I want it to return an empty cell instead in those cases. My attempt was =IF(LOOKUP(J2,Sheet4!$A$2:$A$1000,Sheet4!$B$2:$B$1000)=NA(),0,LOOKUP(J2,Sheet4!$A$2:$A$1000,Sheet4!$ B$2:$B$1000)) however, it still returns a #N/A error. Is there any way around this?
I have a rather large "application" that I've built into a spreadsheet at work (about 1200 lines of code, 4 forms, and code on a few spreadsheets).
I'd like to convert all this code and the forms into a VB6 project so I can have this application as an executable separate from the workbook, if possible.
I tried exporting the forms, but they show in the project explorer as Designers.
When coding my macro to stored to .csv file I encounter a problem.
Buildup file:
Row A: has 24 columns with header info Row B: has 15 columns with header info Row C: has 9 columns with header info Row D: has 24 columns with record info Row E: has 15 columns with record info Row F: has 9 columns with record info Row G: has 24 columns with record info Row H: has 15 columns with record info Row I: has 9 columns with record info etc...........
I am trying to convert a row with cells referring to other cells (or with formulas in them) into columns, but paste special - transpose does not do the trick; the reference somehow changes when I try to paste it in, say A5 in the example file. I have excel for mac.
i try to convert several decimal values into Days Hours:Minutes:Seconds my problem is the following. If i user the format DD hh:mm:ss values over 32 will start counting the days from 0 (like a new month). and if i format it like M D h:m:s values < 32 days gets displayed with a 1 (for the month) before the days.
[Code] ......
is there a way to get only the count of days displayed without the summarization to months?
I am trying to convert cells so that I can pull data into a pivot to only show month & year. I have connverted the format in the cells to custom mmm-yy in the source data w/sheet which displays it how I want it to but the pivot table also picks up the day so instead of having groupings by month/yr I am getting groupings by day/month/year.
How to convert the excel formula into its value? I know the easiest way is to copy and use paste special then "value" options but is there a way to make it automated in case the desired output value has resulted.
HTML example: A1 B1 C1 D1 1 2 A1+B1 Yes/No
on the above example, if D1=Yes, the output C1 will become value equals to 3 and the formula will be remove, if D1=No, the formula will still remain.
I have a lon list of dates in the format dd/mm/yyyy. I can change the format to DDD to show the day of the week. What I want to do though is make that permanent, not just in the format.