Flipping Characters

[Arunima_S]

HI,

I have a string- AB*WX-CD*YZ-EF*YZ

I want to replace "WX" with "YZ" and "YZ" with "WX". Is there any way to flip the characters within the string?

The string length can vary. So I think "Text To Column" option won't work.

Thanks 

[JosephSerpis · Accepted solution]

I mocked up a workflow let me know what you think? Is it those two characters that need flipping?

[Arunima_S]

Thanks for your reply.

Well, its not the characters the need flipping. Think of "WX" as "Yes" and "YZ" as "No". I want to change Yes to No and No to Yes in the entire string.