How to add a an additional condition to this expression

[cliff.clayman]

I have an expression to pull the last name from a full name field that is typically formatted like last name, first name. However, in a couple of examples, I have a company name that contains no commas. How can I add an additional condition to the expression below to just return the full name value when there is no comma present?

Left([Names],InStr(1,[Names],",")-1)

[pbaldy]

Use an IIf(), testing with InStr() for a comma. Return the full string if none, your expression otherwise.

[cliff.clayman]

I understand the concept, can you help with the code itself?

[pbaldy]

IIf(InStr(...) > 0, YourExpression, FieldName)

[cliff.clayman]

Thank you!

[pbaldy]

No problem!