Conditional Convert To Lowercase

Nov 3, 2009

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.)
αυτό είναι δοκιμή (ΑΕΔ)
αυτό είναι δοκιμή (Α.Ε.Δ.)

View 14 Replies


ADVERTISEMENT

Formula To Convert Uppercase Words Only To Lowercase

Apr 18, 2014

Formula that will convert uppercase words longer than three letters, into lowercase. Leaving the rest of the string unchanged?

For example,

Mary and John at IBM thought this was a GREAT OPPORTUNITY. Becomes:
Mary and John at IBM thought this was a great opportunity.

I have also tried using more func's REGEX.SUBSTITUTE but I couldn't get that to work either!

View 7 Replies View Related

Combine 2 Cells Containing Text The Convert All To Lowercase

Dec 17, 2008

combine 2 cells containing text the convert all to lowercase

i.e. in say A1 John, B1 Smith
convert this to c1 johnsmith

this is to me used as a user name generator

then in cell d1 create a 5 digit unique number (password)

View 9 Replies View Related

Check For Lowercase Letters

Nov 17, 2008

Is it possible to do a true/false check for lowercase letters in a cell?

View 4 Replies View Related

Find Position Of First Lowercase In Cell?

Jan 9, 2013

I have in the first column something like this:

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.

View 9 Replies View Related

Changing Lowercase To Upper Case

May 15, 2008

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 _......

View 9 Replies View Related

If Statement To Remove Lowercase Letters

Aug 4, 2008

I'm having trouble with separate a text string.

The first part of the text is in all uppercases and the latter part is in lower cases as seen below.

PLAVIX BLOOD THINNER RXNo Title Assigned - #588303

I have to separate PLAVIX BLOOD THINNER RX and No Title Assigned - #588303

into 2 separate columns from that one column.

Is there a faster way of doing that than doing it manually?

Is there an If statement for that?

View 9 Replies View Related

Case Sensitive Sorting (all Caps First, Then All Lowercase)

Sep 12, 2009

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):

A
B
C
D
E
F
G
a
b
c
d
e
f
g

View 4 Replies View Related

Converting Text From Upper Case Or Lowercase

Aug 8, 2008

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

I currently get
david was not well. he went home.

View 9 Replies View Related

Change First Letter Of Word From Uppercase To Lowercase In Each Cell Of First Row?

Sep 18, 2013

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?

View 5 Replies View Related

Conditional Formula To Convert Number With Positive Value To Its Negative Equivalent

Aug 27, 2012

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.

View 1 Replies View Related

VBA To Convert Conditional Formatting To Fixed Formatting?

Jul 5, 2013

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...

View 9 Replies View Related

Conditional Formatting Based On Another Cell Conditional Format

Mar 20, 2013

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.

Possible???

View 3 Replies View Related

Conditional Median Formula Into Conditional Quartile / Percentile?

Apr 15, 2014

Having trouble changing this formula from its current Median to a Quartile or Percentile. The median formula looks like this:

(MEDIAN(IF(DATA!$B$15:$DZ$15=1000,DATA!$B26:$DZ26))) and works perfect.

However I can't figure out how to manipulate it into a percentile keeping the condition of

IF(DATA!$B$15:$DZ$15=1000)

View 2 Replies View Related

Looping & Conditional Format: Finds A "J" It Will Apply Conditional Formatting To A Row Of 4 Cells Directly Adjacent?

Feb 9, 2009

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.

View 2 Replies View Related

Conditional Percentage Based On Conditional Sum

Mar 13, 2008

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;..............

View 5 Replies View Related

Convert Mm.ss To Hh:mm:ss

Jun 14, 2009

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

If I simply change the cell format to hh:mm:ss,

View 10 Replies View Related

Convert Xls To Csv

Nov 27, 2009

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.

View 10 Replies View Related

Convert #N/A To Zero

Feb 23, 2010

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?

View 3 Replies View Related

Convert VBA To VB6

Dec 8, 2008

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.

View 10 Replies View Related

Convert Mm:ss To Ss Only

Jun 28, 2006

how can I creat a formula say to convert a time (mm:ss) to seconds (ss) only. Is that possible? And how do I do it.

I got a column say of these values and I want whats after "="...

3:07 = 187 sec
1:10 = 70
5:16 = 316
1:25 = 85
5:40 = 340

I have 2 weeks of data that I need to convert the Average handle time to seconds only. All the data is in 30min invertals for a full 24hr day.

View 9 Replies View Related

Convert USD$100 To 100

Nov 17, 2006

A1 = USD$100, I want C1 = 100, What is the formula for C1,

View 9 Replies View Related

Convert UST To EST

Apr 21, 2009

Does anyone have a simply way to convert UST time to EST.

Keeping in mind that we use military time format.

View 9 Replies View Related

Convert With VBA To CSV

May 15, 2009

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...........

View 9 Replies View Related

Convert Date From 24h To 12h

Mar 29, 2014

I have times in 24h clock format and want to change to 12h so 18:00 will look like 06:00 see attached for actual formats

View 10 Replies View Related

Convert Row Into Column?

Mar 28, 2014

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.

View 2 Replies View Related

Convert Decimal Value To DD Hh:mm:ss

Aug 22, 2014

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?

View 4 Replies View Related

Convert To Mmm-yy Only For Pivot

Nov 10, 2008

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.

View 2 Replies View Related

Convert Formula Into Value

Nov 12, 2008

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.

View 2 Replies View Related

Convert Date To Day

Dec 12, 2008

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.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved