LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

Apply the UPPER() function to all the text, then do a Copy/Paste Special
values to convert the results back to text

"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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 07:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"