change text case

's Computer Specifications

i want to change case into proper mode for a colomn which content more than
1000 row

's Computer Specifications

"jackie chan" wrote:
> i want to change case into proper mode for a colomn which content more than
> 1000 row

Assume source in A1:A1000
Put in B1: =PROPER(A1)
Copy down to B1000
Then select col B, freeze values with an "in-place":
Copy > Paste special > Check "Values" > OK
Clean up by deleting col A
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Shourtcut to change text written in upper case to lower case	becksm	Microsoft Word Document Management	4	26th Jan 2010 03:18 PM
Change text from lower case to upper case in Access 2007	Gloria	Microsoft Access	1	30th Dec 2008 06:24 AM
Change the text from lower case to upper case in an Excel work boo	=?Utf-8?B?ZGF2ZTAxOTY4?=	Microsoft Excel Misc	2	9th Dec 2005 09:09 AM
How do I change existing text from lower case to upper case	=?Utf-8?B?Q1QgQ2FtZXJvbg==?=	Microsoft Excel Misc	2	30th Nov 2004 01:07 AM
change lower case text to upper case text	=?Utf-8?B?cm90dHk=?=	Microsoft Excel Misc	2	4th Oct 2004 12:46 AM