Convert Upper Case To Lower Case?

Hi there,

I have a spreadsheet that is downloaded from a network. The names in column C are in upper case and I want to use the "Proper" function to convert to upper and lower case.

Each time I use this function (in column D) it produces the words "=PROPER(C)". Column D is formatted as text. Does anyone know why this occurs?

Thank you.

Hi There,
I am using the "Proper" function to convert customer names from upper case (in column C) to an upper & lower case format (in column D). The code I use is

Range("D2").Select
ActiveCell.FormulaR1C1 = "=PROPER(RC[-1])"

What code can I use to fill column D to the bottom of the data? The number of rows will vary each time.

Please help?

Thanks.

Is there a way that we can convert lower case charecters to upper case in MS
Excel cells? I have more than 150 User ID's written down in Excel using both
Upper case and Lower case. But now I need to convert them in to upper case.
Is there an option for that?

I have done a search but couldn't find anything that helps.

I have inherited an excel file that has approx 500 lines and 20 columns.

Some of the sheet is in lower case and some in upper case.

I would like to be able to convert this sheet to ALL UPPER case.

Could somebody please give me some assistance.

Thank you.

Xerxers

Hi all,

Pl suggest how to convert a given text string to Proper Case by VB code.
VB Code of Upper & Lower Case exsist but couldn't trace for the Proper Case, as we have it in Normal Excel Formula bar.

Thanks & Regards,

Vijay Anand.R

I'm trying to figure out if there is any way of performing a logical check (possibly by way of a custom function?) to ascertain whether a cell contains a text string (no numbers) and is all in upper case (or lower case, or Proper Case).

The reason for this is that I receive approx 10,000 rows of data each month French customers who - for some strange reason - seem unable to tell the difference between a "First Name" and "Surname" field header (in French obviously!)

While most people do complete their data correctly, there is a large proportion where I can tell that the surname has been typed in the First Name field and vice versa. I can tell this because in France it is common practice to type your first name in proper case and your surname/family name in upper case.

What I therefore need is some way of identifying rows where data in Column A (First Name) is in upper case AND where the corresponding data in Column B (Surname) is in lower case or proper case.

Once identified, I can swap the values between columns.

Is there a relatively simple way of creating a logical check (to return TRUE or FALSE) on whether a cell's contents are in upper case, lower case or proper case?

Is there a way to highlight a portion of a phrase in an Excel cell and
convert the phrase to capital letters (lower case to upper case), rather
than retype the entire phrase? Also is it possible to highlight a portion
phrase and have all the first letters of words convert from lower case to
upper case? I have to go through an Excel document and convert sections of
phrases to all upper case letters, I would rather not retype the entire
section. I do not believe a formula will work as a portion of the cell must
be all caps and a portion lower case or proper, and because the data has
already been inputted.

Thanks, Bob

I have macro that counts an "x" in a particular cell on multiple sheets and then reports it back on one sheet. It is all input manually by several users, so sometimes they use Upper case (X) and sometimes they use Lower case (x). How do I make Excel ignore the case and count if it is upper and/or lower case?

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?

I have 3 worksheets in my workbook: "Sheet AA", "Sheet BB", and "DataCC".
Worksheet "DataCC" contains 3 columns and is a monthly mass import from another system:

StreetAddress_1 StreetAddress_2 City
Example



I need a VB to replace/convert data in those 3 columns upon the workbook opening resulting in the following output:



For data in the "STREETADDRESS_1" column I need Proper Case, except for at the end of the addresses where it has "NE", "NW", "SE", "SW". I need these to remain in UPPER CASE.

For data in the "STREETADDRESS_2" column I need Proper Case, only for the words "APT" or "UNIT".

For data in the "City" column I need Proper Case.


Thanks.

Ok, im doing a simple Vlookup into a sheet. Simple enough and got that working, however I have now discovered that they could have the lookup field upper case or lower case this returning different values.

I see a couple of options.

1. check is the lookup is upper case (single letter e.g V or v) then define two lookup arrays one for upper case letters and one for lower. For that one i need to know how to check if the letter is upper or lower case

2. have vlookup recognise upper and lower and have one long lookup array. I have try adding the false critea but it still returns the first occurance of the letter weather upper or lower.

Any one else have an easier way or can answer one of those questions?

Sorry to ask such a simple question, but I'm having no luck in finding the answer myself.

I have a work sheet with a number of columns, all working well.

A 'minor' problem I have is that one column only has Text entry required, no problem, but I would like this Text to always be in Upper Case.
Ok, I can use the Shift key, but I'm no typist and I always seem to mess up and have to make corrections.

Is there a way please that I can enter Lower case or a mixture of Lower / Upper case letters that will always end up as Upper case in this particular column?

Thanks for your time.

magpye (John)

I know how to convert to all Upper case or all Lower case, but I want to take a sentence and convert it to where the first letter of the first word of the sentence is capitalized, and the rest of the sentence is lower case...

is there a function for this, or if not, does anyone have one in their own 'tool' box?

Thanks.

jill

I have multiple sentences invariably with a full stop / period then one space after each and then a lower case letter which starts a new sentence.

I would like to convert all the lower case letters into upper case.

Is there an Excel function which will do this?

I have a database in Access 2000 where the fields have been entered in all upper case. We are converting to a new system and the type will have to be in upper & lower case.

I've been told the easiest way to do this would be to export to Excel.

I just wanted to check first and make sure this cannot be done in Access.

Does anyone know?

Thanks!

I have a file of names and addresses that were entered in all upper case. Is
there a fast way to change this file into upper and lower case? Thanks for
any help you can give me.
--
S Jan

Hi All,

First I need to convert lower case to upper case automatically for a whole work sheet for example you type john smith as soon as you move to next cell it will be JOHN SMITH.
I suppose it can be done either function or Macros. I have never done Macro before but I do like challenge. Would anyone be able to tell me some point to start with? much appreciated.

Regards

I am having some data which are mixed in lower case and upper case,
eg.

GOPALA
krishna
rao
RAMA
KRISHNA
govinda
KRISHNA

HOW TO CHANGE THIS ALL INTO UNIFORM EITHER LOWER CASE, OR UPPER CASE?


SINCERE THANKS TO THE KNOWLEDBLE PERSON IN ADVANCE.

Can someone please tell me how I can convert text in Excel from upper to lower case as a shortcut (rather than using LOWER or UPPER formulas)
Thanks

Tom

I got this macro from some NG some where (Thanks), what I need help on is making the macro ignore all characters in brackets "()".
I am absolutely dying trying to mod this macro.
Heck, is it even possible?

Code:

'Change Text to Upper Case or Proper Case. See Also:
'Force Upper Case/Proper Case

'Excel has 2 built in functions for converting text to
'either UPPER CASE or Proper Case. The 2 functions that
'do this are shown below;

'=UPPER(A1)
'=PROPER(A1)

'These Excel functions work well when referring to cells
'that house the text. However, there are many instances
'when using the Worksheet Function approach is not practical.
'The Excel macro code below can be used to change existing
'text to either UPPER CASE or Proper Case. If you run the
'macro with only a single cell selected it will work on the
'entire Worksheet. If you run the macro with more than 1
'cell selected it will work on only your selection.
'The other settings that the StrConv Function take are
'shown below. See the Excel VBA help for specifics.

Sub ConvertCase()
    Dim rAcells As Range, rLoopCells As Range
    Dim lReply As Long

    'Set variable to needed cells
    If Selection.Cells.Count = 1 Then
        Set rAcells = ActiveSheet.UsedRange
    Else
        Set rAcells = Selection
    End If


    On Error Resume Next    'In case of NO text constants.
    'Set variable to all text constants
    Set rAcells = rAcells.SpecialCells(xlCellTypeConstants, xlTextValues)

    If rAcells Is Nothing Then
        MsgBox "Could not find any text."
        On Error GoTo 0
        Exit Sub
    End If

    lReply = MsgBox("Select 'Yes' for UPPER CASE or 'No' for Proper Case.", _
                    vbYesNoCancel, "OzGrid.com")
    If lReply = vbCancel Then Exit Sub

    If lReply = vbYes Then    ' Convert to Upper Case
        For Each rLoopCells In rAcells
            rLoopCells = StrConv(rLoopCells, vbUpperCase)
        Next rLoopCells
    Else    ' Convert to Proper Case
        For Each rLoopCells In rAcells
            rLoopCells = StrConv(rLoopCells, vbProperCase)
        Next rLoopCells
    End If

End Sub

As always, I value all help provided.

To the MOD who improved my title, Thanks!