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?
Bookmarks