LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 19
Default UPPER function

I have a spreadsheet with cell filled with characters of both upper and lower
case, and I need to change them all to upper case. I have played around
using the UPPER function on another sheet and then copying the subject cell
nmuber on it, and then doing massive copying on the paste sheet. Is there a
simpler way to convert sheet to all upper case? It would be great if I could
highlight the whole page. push a button and it then all upper case. Any
suggestions?
--
John 3:16-19
 
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
Excel UPPER function Neil Excel Worksheet Functions 1 August 14th 09 03:57 PM
UPPER text function Graham Excel Discussion (Misc queries) 5 June 6th 05 06:32 PM
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
Help With The Upper Function Dmorri254 Excel Worksheet Functions 3 November 5th 04 08:22 PM
UPPER Function Dmorri254 Excel Worksheet Functions 1 November 5th 04 07:57 PM


All times are GMT +1. The time now is 01:19 PM.

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"