Hi,

I am new to vba and am stuck on how I get the below split into three columns?

A1=102341,80USD0,00

A2= 102341.80 (will also change the comma to a decimal afterwards)
A3=USD
A4=0,00 (will be deleted afterwards)

Thanks