Is there way in which I can change the case of a list in a MS Excel spreadsheet?

Question

I have a list of names which I need to use for a mail merge but this list is in capital letters. I know you can easily change case in MS Word but is there something similar (not too complicated) in MS Excel?

Answer 1

two ways;

Method 1 (direct editing in individual cell)
===============

if your text is
Name

add this in front
=UPPER("

and add this at the end
")

you will end up with =UPPER("Name")

Method 2
=============
alternatively, if the cell you want to change is A1
you can enter the following in another cell

=UPPER(A1)


since you said its a list,

you can insert a column of your new UPPERCASE list beside the old list.

lets assume your the first cell in your list is A1 [Name]
and your first cell in UPPERCASE list is B1

Step 1. in column B2
Type =UPPER(A1) then press enter,

Step 2.
hover your mouse on the bottom right hand corner of the B2 cell. When your pointer changes to a crosshair, click and drag down to the bottom of your list.

it would copy the formular and save you time

Answer 2

Let's say you want to convert text from uppercase to lowercase or from lowercase to proper case to make it more readable. To change the case of text, use the UPPER, LOWER, or PROPER functions.

Example
The example may be easier to understand if you copy it to a blank worksheet.

How to copy an example

Create a blank workbook or worksheet.
Select the example in the Help topic.
Note Do not select the row or column headers.



Selecting an example from Help

Press CTRL+C.
In the worksheet, select cell A1, and press CTRL+V.
To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.
A=Name contains the value nancy davolio

Formula Description (Result)
=UPPER(A2) Changes text to all UPPERCASE (NANCY DAVOLIO)
=LOWER(A2) Changes text to all lowercase (nancy davolio)
=PROPER(A2) Changes text to Title Case (Nancy Davolio)

Answer 3

Highlight the things you want to change and press SHIFT+F3