Capitalization of first word in a cell

D

Dave

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.
 
B

Bob Phillips

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)
 
D

Don Guillett

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
 
R

R. Choate

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


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.
 
R

Rae Drysdale

Tools |Autocorrect Options. Check the box to Capitalize first word in
sentences.
 
R

R. Choate

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


Tools |Autocorrect Options. Check the box to Capitalize first word in
sentences.
 
Top