I am new to this forum and desperately need help. I have to print 9,275
envelopes. When my client sent the excel list, it is in all caps. I
can't for the life of me figure out how to change all caps to upper and
lower case that I need.

I don't know excel very well and would sincerely appreciate any help
that anyone can give.

Many thanks, Harvest


--
Harvest
------------------------------------------------------------------------
Harvest's Profile: http://www.excelforum.com/member.php...o&userid=37747
View this thread: http://www.excelforum.com/showthread...hreadid=573319

Ok, since you're new to to Excel, I'll take this step by step.

If there are no empty sheets in the workbook, use Insert | Worksheet to get
a new, empty sheet into it.

Assuming that your current list starts in cell A1 on a sheet, go to cell A1
on the new sheet and enter
=Proper(
and then click on the sheet with the current information on it and click
cell A1 there, then type a closing parenthesis and hit enter. The formula
should look something like this
=Proper('SheetName'!A1)

Move your cursor to the lower right corner of cell A1 on the new sheet with
the one formula on it until it becomes a small + symbol instead of the
regular large cross, then press and hold the left mouse button and drag
across the row until you've gone as far across the new sheet as your data
goes on the old sheet. Release the mouse button and you should see the text
from the entries on the old sheet in that row.

Now highlight the cells from A1 over to where you stopped before and then
move the cursor to the lower right corner of the right-most cell and press
and hold the left mousebutton again and drag down the sheet to the end of the
rows used on the first sheet.

Don't worry if you accidentally release the mouse button in the middle of
things, you can just highlight the info in the last row you made it to and
again start dragging down the sheet.

If you go too far, no big deal you can just delete any extra columns/rows of
stuff - rows will probably be more important than columns to delete for a
mailing list.

What PROPER() does is change to "proper case", for instance JLATHAM would
become Jlatham, it pretty much changes things to the way you'll want most of
it.

There are other ways to 'fill' the formulas across/down the sheet, but I
think this way is the best to offer to you right now.

"Harvest" wrote:


I am new to this forum and desperately need help. I have to print 9,275
envelopes. When my client sent the excel list, it is in all caps. I
can't for the life of me figure out how to change all caps to upper and
lower case that I need.

I don't know excel very well and would sincerely appreciate any help
that anyone can give.

Many thanks, Harvest


--
Harvest
------------------------------------------------------------------------
Harvest's Profile: http://www.excelforum.com/member.php...o&userid=37747
View this thread: http://www.excelforum.com/showthread...hreadid=573319

Have a look at the Proper function:

=PROPER(A1)

--
Damon Longworth

2006 West Coast Excel / Access User Conference
October 25-27th, 2006
Marina del Rey Hotel
Marina del Rey, California USA
http://www.exceluserconference.com/WCEUC.html

"Harvest" wrote in
message ...

I am new to this forum and desperately need help. I have to print 9,275
envelopes. When my client sent the excel list, it is in all caps. I
can't for the life of me figure out how to change all caps to upper and
lower case that I need.

I don't know excel very well and would sincerely appreciate any help
that anyone can give.

Many thanks, Harvest


--
Harvest
------------------------------------------------------------------------
Harvest's Profile:
http://www.excelforum.com/member.php...o&userid=37747
View this thread: http://www.excelforum.com/showthread...hreadid=573319

You could use a macro to update the data in place.

Chip Pearson has one:
http://cpearson.com/excel/case.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Harvest wrote:

I am new to this forum and desperately need help. I have to print 9,275
envelopes. When my client sent the excel list, it is in all caps. I
can't for the life of me figure out how to change all caps to upper and
lower case that I need.

I don't know excel very well and would sincerely appreciate any help
that anyone can give.

Many thanks, Harvest

--
Harvest
------------------------------------------------------------------------
Harvest's Profile: http://www.excelforum.com/member.php...o&userid=37747
View this thread: http://www.excelforum.com/showthread...hreadid=573319

--

Dave Peterson