Hi - Hope you can help. I've got long strings of data of varying lengths in a single column. I want to be able to extract the value which is always four semi-colons from the end irrespective of the length of the data in the cells. In the shortened example below, I am trying to extract the value '85.60'. I'm not very good, but have tried various options involving substitution, find, mid, etc, but am sure there must be a more elegant formula. Any help would be massively appreciated!
31/03/2015;134.00;702.00;73.90;0.0;0.0;0%;20.00;31/03/2016;103.00;819.00;85.60;0.0;0.0;0%;22.00
Many thanks,
Ade.