LinkBack URL
About LinkBacks
I cant get excel to capitalize the first letter of every word in a cell as i type any ideas.
This is the code i have that doesn't work.
Please Login or Register to view this content.
I cant get excel to capitalize the first letter of every word in a cell as i type any ideas.
This is the code i have that doesn't work.
Please Login or Register to view this content.
Last edited by randall78; 07-14-2012 at 03:08 AM.
Hi randall78,
First would suggest you to use the code tags going forward
Now use the below code where I have just inserted one extra line :-
Regards,Please Login or Register to view this content.
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
Select your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:
... and appear like this when postedPlease Login or Register to view this content.
Last edited by zbor; 07-14-2012 at 03:02 AM.
Highlight your code and click the # at the top of your post window.
Uops, sorry, I've edited wrong post above
But you can see a guide in your post.
Cool thanks for the help with the "Me breaking another rule thing". Guess I should of read the rules. Oops, I hope the first rule isn't to read the rules, cos if so I'v just confessed to breaking another one.By the way, still cant get the first letter of every word in a cell to have a capital, (with out using the shift key cos I am lazy).
Use this shg solution:
Change column as you need
http://www.excelforum.com/excel-prog...=1#post2497606
Please Login or Register to view this content.
Let's see if this works for you
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks