Move mathematical symbol to First position

[RA6]

Hello all,

I have column A which contain negative sign - at the last position and i want to check if the value contains negative sign, then i want to move the symbol to the first position.

Is it possible?

For example :

Column A	Expected Result
45.50 -	-45.5
8841.74 -	-8841.74
966	966
50.25	50.25
23.5	23.5
445	445
415.99-	-415.99

Can you advice on this please?

Best regards,

asadasing

[vboppudi · Accepted solution]

By using tMap you can achieve this.

[RA6]

vboppudi, 

I can guarantee that you are doing an awesome work.

Thank you very much for your help.