IF statements with special characters

DanBonn

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.

Paul Newcome

Are you able to provide some screenshots for context?

DanBonn

I found it! Making me review the lengthy IF statement i realized there were 2 competing statements for the same facility. One forced it to replace it with "" and the other offered a full name. Once i removed the "", the formula worked. Thanks for making me review!

Dan