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