Formula to Split up string of text

[kenadams378]

Morning,

In the attached document i have a string of text that i need to split up into 4 cells;

Currency 1
Value 1
Currency 2
Value 2

I've already added the formula for currency 1 as it was fairly easy LEFT function but unsure with the others, could anyone help by adding the formulas to the yellow cells below the hardcoded values?

[Fotis1991]

Hi

Are always your first vales with 6 digits and your second with 8?

[Pete_UK]

Use the following formulae:

D2: =MID(A2,4,FIND("/",A2)-5)*1
E2: =MID(A2,FIND("/",A2)+2,3)
F2: =RIGHT(A2,LEN(A2)-FIND("/",A2)-4)*1

Hope this helps.

Pete

[samba_ravi]

see the attachement