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
=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