How to move a character to another column

[monigarza]

Hey all, does anyone know how to transfer one character to another column? For example, I want to move that "0" from column G to column F, right at the end. So that the amount in column F is equal to "9,500.400". 

I have tried with the formula tool applying the next conditional: 

IF [Currency]= "MXN" THEN "MXN" ELSEIF [Currency]= "USD" THEN "USD" ELSE ENDIF 

But I just don't know how to complete the formula, or what should I do in order to get the result that I want. 

Please help me, thanks in advice!! 

[DavidP · Accepted solution]

Probably the easiest thing to do is to combine the 2 columns:

[New Column]:

if Contains([Currency],' ') then [Foreign Currency] + [Currency] else [Foreign Currency] +' '+ [Currency] endif

then do Text to columns with a space (\s) as delimiter

[monigarza]

Thank you so much!! It totally worked!! 🙂