Hi I have successfully used ( =RIGHT(B3;LEN(B3)-SEARCH(" £";B3;1)) ) to extract my value from a string but how do I total the extracted values
Total Price £0.45 £0.45
Total Price £1.10 £1.10
Total Price £0.45 £0.45
Total Price £1.00 £1.00
Total Price £0.58 £0.58
Grand Total £0.00
PS How do you thank people for their help
[Edit - Opaque] Formatted table as preformatted text for better readability.