# Thread: Conversion of lower case characters to uppercase (2003)

1. ## Conversion of lower case characters to uppercase (2003)

Is there a way to convert lower case characters to upper case characters?
Any help would be appreciated.

2. ## Re: Conversion of lower case characters to upperca

=UPPER("lowercase") will result in "LOWERCASE"

Cheers
Peter

That

4. ## Re: Conversion of lower case characters to upperca

The attached worksheet example should help? Column D in Yellow shows how to convert to upper case the values in column A. Column F in blue shows how to use the UPPER function within a formula.

You need to decide what it is you are trying to do with the data in order to decide how best to handle it? If this is a one time excercise you can just use a brute force method like Column D in the attached:

Find an empty column somewhere
Insert the formula =UPPER(A2) in XXX2 - Where XXX is the empty column you are using
Copy and paste the formula in XXX2 all the way down to XXX9999 - Where 9999 mathces the last row that has data in Column A
Highlight and copy the RANGE XXX2 : XXX9999
Position the cursor in A2
On the Excel Menu, click Edit, Paste Special. Click on Values and then click OK
The data in A2:A9999 wil be replaced by the UPPER case data you created in column XXX
You can delete the entries in column XXX if you want to

The above is fine if you are only ever going to do this once.. If this data is going to be re-entered, re-imported, sent to you frequently, your BEST option is to ask for the data in the format you need it. If you can't do that, you can either use the above technique to re-create the data in Column A in another column (Column F in my example) and refer to your new column in any calculations/lookups etc. Failiing that, create a copy sheet as shown in the attached worksheet (I've called the sheet Copy, use a more meaningful name!) - Look at the formulas cells A2:A20 and B2:B20.

Hope the above helps. Good luck!

Cheers
Peter

5. ## Re: Conversion of lower case characters to upperca

That

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•