Create a Full Name field with concantenate

[Sara H]

Hey all,

This is no doubt a really easy thing to do but it's making me pull my hair out. I need to set up a text calculation that says, basically:

First Name & "and" & Partner First (if there is one) & Last Name

The idea is to create a Full Name field.

Most of the time there's no Partner First, so I need and If function in there, and the "and" to only appear if there's an actual Partner First. That's where I get thrown - the 'if' part.

I'm having a heck of a time so any assistance would be appreciated.

Sara

[comment]

How about:

First Name & Case ( not IsEmpty ( Partner First ) ;  " and " & Partner First ) & " " & Last Name

Note the spaces.

[Sara H]

That worked great! Thank you so much!

Sara