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