change data of entire column from small case to upper case

's Computer Specifications

How do I change the data of an entire column from small case to upper case?

Thanks!

's Computer Specifications

You can use an adjacent (newly inserted???) column.

Then fill it with formulas like:
=upper(a1)

Then you can copy this column and paste special|values over the original
column. Then delete this helper column.

Ann wrote:
>
> How do I change the data of an entire column from small case to upper case?
>
> Thanks!

--

Dave Peterson

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
convert to upper case - entire column ?	=?Utf-8?B?QWxpY2lh?=	Microsoft Excel Misc	2	18th Mar 2007 03:25 PM
Change entire column in spreadsheet from upper case	=?Utf-8?B?SkxT?=	Microsoft Excel Misc	1	8th Jun 2006 08:58 PM
excel'03 how to convert a column from upper case to proper case	=?Utf-8?B?c2hhcmllIHBhbG1lcg==?=	Microsoft Excel Misc	1	30th Jan 2006 11:50 PM
HOW DO YOU CHANGE AN ENTIRE SPREAD SHEET FROM LOWER CASE TO UPPER	=?Utf-8?B?RFJQQVRSSUNLMg==?=	Microsoft Excel Misc	2	24th Aug 2005 08:51 PM
How do I change a column in Excel from upper case to lower case?	=?Utf-8?B?RGViYmllIEtlbm5lZHk=?=	Microsoft Excel Worksheet Functions	3	2nd May 2005 06:57 PM