How to convert entire excel document from lower to upper case

Gord Dibben

Posts: n/a

Paul

This would require a macro if you don't want to follow Duke's formula method.

David McRitchie has the appropriate macros at his site.

http://www.mvps.org/dmcritchie/excel/proper.htm

Gord Dibben Excel MVP

On Fri, 1 Apr 2005 05:09:02 -0800, "Paul"
wrote:

I'm merging several excel documents and some are lower case and some are all
in upper case. How can I convert the entire document from one to the other?
Thanks for any suggestions I get.
Paul

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I convert all upper case excel sheet into upper and lower .	DebDay	Excel Discussion (Misc queries)	1	March 9th 05 08:31 PM
How to convert excel Docs to pocket excel on my mobile device	New User again	New Users to Excel	1	March 8th 05 07:02 PM
Convert to Lower case (not with a function)	TAJ Simmons	Excel Worksheet Functions	2	December 29th 04 10:33 PM
Getting specific data from a word document into an excel sheet	smintey	Excel Worksheet Functions	3	December 7th 04 05:17 PM
Copying an Excel spreadsheet to a Word document	KG	Excel Discussion (Misc queries)	1	November 28th 04 07:38 PM

All times are GMT +1. The time now is 04:31 AM.

Menu

About Us