How to delete characters in a cell in Excel under certain conditions?

Question

excel

Good afternoon, we have cells with the following value
{male, female}
{male}
{female}

How do I remove curly braces in cells that do NOT have a comma? That is, so that it becomes like this

{male, female}
male
female

Answer 1

In exact accordance with the given example.

=ЕСЛИ(ЕОШИБКА(ПОИСК(",";A1));ПОДСТАВИТЬ(ПОДСТАВИТЬ(A1;"{";"");"}";"");A1)