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


View 4 Replies


Case Sensitive Sorting

Jun 8, 2009

I have been battling with excel for weeks now trying to get some data to display the way I want it to.

The plan is to enter (into individual cells) some letters, some lower case, some upper case ie, A A a A a C d. Some of these will be displayed together in another cell like this: AAaA, AaCd. My problem is that I want them all to be displayed Upper case letters first, lower case second like this: AAAa, ACad. No amount of my inexperienced fumbling with excel's tools has worked so far.

I am playing around with a table for genetics so if my results in a cell are aAbBCcdD, I need it to display: AaBbCcDd. Is it possible?

View 14 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

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

David was not well. He went home

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

View 9 Replies View Related

Case Sensitive Counts

Jul 1, 2006

I have a spreadsheet which I use to count the occurrences of a value against a range. Basically if the value is uppercase I count as 1 and for lowercase 0.5

This spreadsheet is used as a holiday chart and I have previously used the formula below however, for some reason it no longer works. Not even if I change the lookup value.

The exact function takes a single cell as its value but I have a spreadsheet which allows a range. Although I cannot change it….

=SUM(IF(EXACT(B1:AF99, "LB"),1))+SUM(IF(EXACT(B1:AF99, "lb"),0.5))

View 3 Replies View Related

Lower Case To CAPS

Oct 6, 2009

I have looked in conditional formatting, but do not see a way to change lower case to all caps. Is there a way to do this so that when someone types in a cell it returns all caps instead of leaving it in lower case?

View 9 Replies View Related

Making This Macro Non Case-sensitive

Dec 17, 2007

in making this macro non case-sensitive. So when a user searches a company name in the worksheet they do not require to type in the company name exactly as it appears.

For example; when searching Microsoft they can type "microsoft" and the macro would take the user to Microsoft.

I would also like to know if it is possible to add a feature that keeps the search dialogue open so the user can search the next possible match. If the user was to type in "mirco" and the search would show the user any company name with the word micro in it.

Sub Button3_Click()

Dim datatoFind
Dim sheetCount As Integer
Dim counter As Integer
Dim currentSheet As Integer

View 9 Replies View Related

Substitute Function Non-case Sensitive

Nov 2, 2006

is it possible to make a SUBSTITUTE finction non- case sensitive?

For example I want to replace all letters "e" and "E" in a cell.

View 3 Replies View Related

Case Sensitive Conditional Formatting ...

Aug 12, 2007

I have recently taken on the task of creating a large protected program (without macros) that automatically updates a PowerPoint presentation. I created corresponding workbooks for each sheet in the original (master) workbook. The corresponding workbooks are then used to paste object into the power point presentation. The only problem is it will not update format (text color) changes into the corresponding workbook. I have solved half the problem with conditional formatting, but I want to conditionally format the color of text to two different colors blue if Aa and Red if all CAPS. how to differentiate between Standard word and All CAPS in the conditional formatting.

View 7 Replies View Related

Case Sensitive Conditional Formatting

Feb 25, 2008

I need a macro that will format a a column based on content that is case sensitive. Example, a cell that contains a capital 'P' will be shaded gray with red text where a cell that contains a lower case 'p' will not change format.

View 3 Replies View Related

How To Join 2 Lists Based On Case Sensitive ID

Jan 17, 2014

I've 2 lists that contain similar info but 1 of the lists holds info I need to join.

I've a unique case sensitive id that I'd like to use to join the lists.

I usually use VLOOKUP but it is case insensitive and I cannot understand how to make it case sensitive.

The 2 lists are in 2 separate worksheets as they each hold a lot of data.

View 3 Replies View Related

Case Sensitive Textbox Validation Against Numbers

Aug 15, 2007

I have a user form to get some input from the user and want to make sure that in some textboxes user should be able enter only text i.e A to Z or a-z no numbers or special charecters.

Private Sub CommandButton1_Click()
Dim RegEx As Object
Dim Strng As String

Strng = CStr(Me.TextBox1.Value)
Set RegEx = CreateObject("vbscript.regexp")
With RegEx
.Pattern = "^[A-Z]{2}/d+/d{2}$"
If Not .test(Strng) Then MsgBox "Invalid Format: TextBox1"
End With
Set RegEx = Nothing
End Sub ..............................

View 9 Replies View Related

Removing Duplicate Values From Column - Case Sensitive

May 22, 2013

Suppose I have some data in a column like below


I need a macro or excel formula so that it will remove duplicate products- case sensitive(removing all duplicate prod using using excel,that i know.) i.e. it should not consider Blue BLUE as duplicate. only consider Blue Blue as duplicate.

So the macro should work same as data -> remove duplicate function already exists in excel, except it will be case sensitive..

View 7 Replies View Related

Excel 2010 :: VLOOKUP Is Acting Case Sensitive

Mar 2, 2012

I am using the this formula to look up data using 0 to show not found. VLOOKUP is acting case sensitive. The Master Array data is in caps and the input is in lower case. There are no spurious spaces. Here are the results:

Code Name
0 River Branch Foundation = not found
X RIVER BRANCH FOUNDATION = found - in array as caps

The formula:
=IF(ISNA(VLOOKUP(B2,'[Master Array - 2012.xlsx]Master Array'!$A$2:$B$3053,2,FALSE)),0,VLOOKUP(B2,'[Master Array - 2012.xlsx]Master Array'!$A$2:$B$3054,2,FALSE))

View 4 Replies View Related

Excel VBA - Compare Words / Inputs Without Case Sensitive?

Aug 25, 2013

I have an issue with case sensitive while creating forms in Excel VBA. When i compared the text "EXCEL" and "excel" it showing as both the words are not equal/same.

Is there any code to compare the words/inputs without case sensitive.

View 2 Replies View Related

Data Consolidate - How To Maintain Case Sensitive Data After Merging Cells

Dec 8, 2013

I'm looking for a way of keeping case sensitive data in a range of cells, before using Data Consolidate, which when merged afterwards, Consolidate removes the case sensitivity and combines the quantities into one.

Check out this simple table as an example >




[Code] .........

Cells A1-B7 and C1-D7 are two sets of original data, before consolidation.

Cells E1-F4 are the result of applying a Data Consolidate operation to the A1-B7 and C1-D7 ranges - note how the merged result ignores the case sensitive condition in the original ranges.

Cells G1-H7 is the post-consolidation result that I'm looking for, where the original text case is maintained.

View 3 Replies View Related

Changing Text From All CAPS To Caps

Apr 20, 2009

Does anyone have a way to change columns of text entered in all caps to the initial capital letter and the rest of the text in small letters.

As in: JONES to Jones.

View 6 Replies View Related

Change ALL CAPS To Initial Caps Only

Sep 6, 2005

Add a column next to the first name. The in that column use the formula
=Proper(A1), A1 being the cell that contains the first name. Then copy that
cell down. Do the same for Last Names. Then keep the cell values, and delete
the original set.

Should be an easier way I think (selecting the entire column and using
conditional formatting) but MS hasn't seen fit to do this yet.

John C. Harris, MPA
JCZ Consulting Services, LLC

"Robert Judge" <> wrote in message
>I have an EXCEL worksheet with columns including first name and last name,
> all capital letters:
> Column A is JOHN
> Column B is SMITH
> How can I change all the names so that, for example, JOHN becomes John and
> SMITH becomes Smith?

View 14 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

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?


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 View Related

Find Position Of First Lowercase In Cell?

Jan 9, 2013

I have in the first column something like this:

GLOBAL DESCRIPTION1 Particular description1
GLOBAL DESCRIPTION1 Particular description2
GLOBAL DESCRIPTION2 Particular description1
GLOBAL DESCRIPTION2 Particular description2

I want to to have in the second column:

Particular description1
Particular 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

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

Add Characters Between Lower Case And Upper Case Letters

Aug 26, 2009

I have a string of names that run together without spaces or commas between each name.

"Danny TrejoJean Claude van DammeVincent SchiavelliGabrielle FitzpatrickDavid 'Shark' FralickPat Morita" for example.

Is there a way to add a comma and space between a lower case and upper case letter?

View 7 Replies View Related

Proper Case/Sentence Case In Macro Code

May 8, 2008

Sub Addy()
Do Until ActiveCell. Offset(0, -4) = ""
Renamer = Proper(ActiveCell)
ActiveCell = Renamer
ActiveCell.Offset(1, 0).Select
End Sub

fail? Trying to remove all capitals from names/addresses. Error message is "compile error - sub or function not defined"

View 6 Replies View Related

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

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

Select Case, Case Else Copy From Above Cell

Jun 3, 2009

I've got a pretty intense macro already written, a lot of Select Case components. At the end, if nothing matches I'd like to just copy the cell above to the cell below. However, there is a range of about 400 cells in length, so I'd need some sort of wildcard for range.

Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
Dim Cell As Variant
For Each Cell In Range("A1:OL1")
Select Case Cell.Value
Case "Eng1"
Cell.Offset(1, 0).Value = "Engine One"
tons more in the middle here
Case Else
Cell.Offset(1, 0).Value = "N/A"

Rather then returning "N/A", how could I reference the cell above and just copy it instead?

View 9 Replies View Related

Caps To First Letter Cap..

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

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 View Related

Set CAPS-LOCK On And Off

Nov 21, 2009

Would like to set CAPS-LOCK On and Off using VBA. Can someone help please?

View 5 Replies View Related

Copyrights 2005-15, All rights reserved