IF statements with special characters

Options

I am building a multiple IF statement series to convert names into something that is compatible with a naming convention. I've run across a challenge with some names having special characters and the IF statement is not recognizing a name with special characters.

Example convert "HEART & SPINE" to "Heart and Spine 0012345"

The IF statements work well until a a special character is included in common name, & . '

appreciate the assist.

Answers