capitalizing first letter of a word in columns

's Computer Specifications

I need to capitalize the first letter of each work in a roll of 110 columns
and I really don't want to go to them one at a time Is this possible?

's Computer Specifications

You can use the Proper function
In Cell A1 you have "hello world"
in Cell B1 =Proper(A1) will return "Hello World"
--
HTH...

Jim Thomlinson

"Tigger" wrote:

> I need to capitalize the first letter of each work in a roll of 110 columns
> and I really don't want to go to them one at a time Is this possible?

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Capitalizing first letter of data in a query	Sarah at DaVita	Microsoft Access	1	7th Jul 2009 05:17 PM
How do I prevent Outlook from capitalizing 1st letter of every lin	=?Utf-8?B?VGVjaHJvb2tpZQ==?=	Microsoft Outlook Discussion	4	25th Jun 2007 12:26 AM
Capitalizing the first letter in a sentence.	=?Utf-8?B?RGltYXMgUGVyZXo=?=	Microsoft Access	3	27th Jan 2006 09:46 AM
Re: automatically capitalizing word following letter plus a period	Suzanne S. Barnhill	Microsoft Word Document Management	1	14th Apr 2005 01:37 AM
Capitalizing the first letter	Shawna	Microsoft Access Forms	0	15th Aug 2003 12:00 AM