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