Removing sign from data

[SCK]

Hi all. I need help in replacing the sign from suffix to prefix of the data. refer to the attached input and output. please help

[grazitti_sapna · Accepted solution]

Hi @SCK ,try this.

Formula- REGEX_Replace([marks], "(.*)\-", "\-$1")

Thanks.

[Assaf_m · Accepted solution]

Check the attached solution, 

please let me know if it works for you.

[grazitti_sapna · Accepted solution]

Hi @SCK,

Alternate Solution.

I hope it helps

[SCK]

All solutions worked, thank you so much!