Capitalize only first letter in sentence

C

ChrisHT

In Excel 2003, I am referencing a text string and would like to return the
text string with only the first letter capitalized. The PROPER function does
not do this, as it capitalizes the first letter of every word. The formula
below does however perform this, but I would like to write it as a
User-Defined Function, similar to the Proper function, so it can be applied
to multiple different workbooks:

=UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))

Is it even possible to write a User-Defined Function to complete this
seemingly simple task and, if so, how do I do it?

Thanks,
Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word isn't capitalizing the first word of each sentence 2
Improving Macro That Keeps First Letter 0
Capitalize first letter in sentence 13
Problem with SET & REF function 0
Keep First Letters, with exceptions 0
Selecting the first sentence of multiple paragraphs in Word 2007 2
Need Help Creating a Word 2010 Chistmas Letter Template 8
Select Text to End of Footnote 9

Top