Standardizing Names - Formula Text
Hi All! Can anyone advise on how I may need to change this formula to account for multiple names? My goal is to capitalize the first letter of each name. In most cases, there are only two name...
Forum Discussion
This should do the trick:
var text one = Upper(Left(Part ([Name], 1, " "),1)) & Lower(NotLeft(Part ([Name], 1, " "),1));
var text two = Upper(Left(Part ([Name], 2, " "),1)) & Lower(NotLeft(Part ([Name], 2, " "),1));
var text three = Upper(Left(Part ([Name], 3, " "),1)) & Lower(NotLeft(Part ([Name], 3, " "),1));
List(" ", $one, $two, $three)Output:
You can even extend it to support more names by adding more variables and popping them into the List function.
------------------------------
gary
------------------------------
Thanks so much!!! Worked great!!
------------------------------
Laura Natal
------------------------------