Hi
in excel if i write a word in a column how to get the first letter automatically to capital.
if i write a sentence in excel the first letter of that sentence should come as uppercase
please support
Hi
in excel if i write a word in a column how to get the first letter automatically to capital.
if i write a sentence in excel the first letter of that sentence should come as uppercase
please support
If vba, look at the vb help about StrConv function with vbProperCase parameter.
If not Proper function is the one you are looking for.
This is what Jindon meant.
Place the following code on Sheet Module (not on standard module). To place the code on sheet module, right click the Sheet Tab --> View Code --> paste the following code into the opened code window --> Close the VBA Editor --> Save your workbook as Excel Macro-Enabled Workbook.
The following code will do what you want for column A and if it is not the column A in actual workbook, just the change the column index in the line Target.Column = 1, here 1 is column index no. for column A.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks