LauraNatal
Qrew Member
2 years ago

# 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 names but there could be more than three as well...

This is my current formula...

Upper(Left([LAST_NAME],1)) & Lower(NotLeft([LAST_NAME],1))

Thanks so much for your help!

------------------------------
Laura Natal
------------------------------
• 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
------------------------------