IF statements with special characters

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
-
Are you able to provide some screenshots for context?
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 500 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives