Capitalization of first word in a cell

I had this set up on my old computer, but can't seem to find how to get it
set up on the new computer I just got.

I want the first word in a cell to be automatically capitalized.

Thanks.

--
Dave

In Excel?

You can get it in another cell with

=UPPER(LEFT(A1,1))&MID(A1,2,255)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Dave" <[email protected]> wrote in message
news:[email protected]...
> I had this set up on my old computer, but can't seem to find how to get it
> set up on the new computer I just got.
>
> I want the first word in a cell to be automatically capitalized.
>
> Thanks.
>
> --
> Dave

right click sheet tab>view code>insert this.
You may want to restrict to certain columns/rows???

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Target = Application.Proper(Target)
Application.EnableEvents = True
End Sub

--
Don Guillett
SalesAid Software
[email protected]
"Dave" <[email protected]> wrote in message
news:[email protected]...
>I had this set up on my old computer, but can't seem to find how to get it
> set up on the new computer I just got.
>
> I want the first word in a cell to be automatically capitalized.
>
> Thanks.
>
> --
> Dave

You might also check out the text tools in the J-Walk PUP add-in. Go to the J-Walk site (John Walkenbach) at
http://j-walk.com/ss/pup/pup6/index.htm

This add-in is really the best thing since sliced bread. I've used it for years and could not work without it. He gives you a free
trial and the registration is cheap if you decide to keep it.

HTH
--
RMC,CPA


"Dave" <[email protected]> wrote in message news:[email protected]...
I had this set up on my old computer, but can't seem to find how to get it
set up on the new computer I just got.

I want the first word in a cell to be automatically capitalized.

Thanks.

--
Dave

Tools |Autocorrect Options. Check the box to Capitalize first word in
sentences.
--
Rae Drysdale


"Dave" wrote:

> I had this set up on my old computer, but can't seem to find how to get it
> set up on the new computer I just got.
>
> I want the first word in a cell to be automatically capitalized.
>
> Thanks.
>
> --
> Dave

How stupid of me. I didn't even think of the most obvious answer. Although I feel like an idiot for not remembering the built-in
feature, I will still recommend the PUP add-in because it is very useful for any Excel user, and I do consider it indespinsable.

Thanks!

--
RMC,CPA


"Rae Drysdale" <[email protected]> wrote in message news:[email protected]...
Tools |Autocorrect Options. Check the box to Capitalize first word in
sentences.
--
Rae Drysdale


"Dave" wrote:

> I had this set up on my old computer, but can't seem to find how to get it
> set up on the new computer I just got.
>
> I want the first word in a cell to be automatically capitalized.
>
> Thanks.
>
> --
> Dave