I am trying to convert a field that is not a user field to be able to read first name, middle name, last name. I have a field that reads last name, first name middle name/initial (Smith,John Q). I want a field where I can convert it to read as John Q Smith. I have found a formula that I think may work but when I try it, it just shows the original format (Smith,John Q). Is there something I need to update or another formula to use to accomplish this?
Can you describe the "...field that reads last name, first name middle name/initial?"
Is that a formula field text reading from three regular text entry fields, first name, etc?
+9If the field holds Smith,John Q as a single text value, a formula - text field can flip it. Left and NotLeft split on the first comma:
If(Contains([Name], ","), Trim(NotLeft([Name], ",")) & " " & Trim(Left([Name], ",")), [Name])That gives you John Q Smith. Trim handles names typed with a space after the comma, and the If passes the value through unchanged when there's no comma.
Swap [Name] for your field's name. If you're still getting the original format back, post the formula you're using and I'll take a look.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.