Share
Report
496Hello,
Hope you're doing well!
Problem:
I would like to capitalize the first letter for the first name and the first letter of the last name, for example, "john,doe".
Expected result:
john,doe ----> John Doe
Proper case function will not solve it because there is a comma "," delimiter.
What I used:
Replace(Dropdown1.Selected.Value,1,1,Left(Upper(Dropdown1.Selected.Value),1))
This formula allowed me to replace the first letter of the first name but I couldn't manage to implement it on the second part to make the last name's first letter uppercase.
What's the best practice function to use to achieve the above result?
Any help will be highly appreciated.
Thank you!
Categories:
I have the same question (0)
All responses (
Answers (
