I'm trying to create an "If" formula that will return lastname and firstname if the middlename column is blank. I also want the result to be lastname, firstname, and middlename if the middlename column is not blank.

This current formula I'm using returns "null" if a middlename is not present:

=IF(ISBLANK(Middle),CONCATENATE(Last, ", " ,First), CONCATENATE(Last, ", ", First," ",Middle))

1 Answer 1


Your formula works in my SPO site.

enter image description here

Is the middle name column a Single Line of Text column? How is the data added? Typed, Imported, via web service?

You might try:

middle = ""

in place of:

  • Thankyou for your help. Your solution of changing middle =" " was a perfect fix.
    – Clayton
    Commented Jul 1, 2019 at 17:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.