How to move a character to another column

Question

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 Answer

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