Hi there, I am a student working on a political project analysing donations to politicians for my dissertation. I would really appreciate your help with this!
In some cells (in the B column) I have a short paragraph of text such as the following:
Name of donor: Government of GibraltarAddress of donor: 6 Convent Place, Gibraltar GX11 1AAEstimate of the probable value (or amount of any donation): Flight £251, meals £120 and hotel accommodation with a value of £258; total value £629 Destination of visit: Gibraltar Dates of visit: 16-18 May 2018Purpose of visit: Fact finding mission to assess impact of Brexit on Gibraltar.(Registered 24 May 2018)
I am looking for a formula to extract the Total Value of the donation so essentially I was trying to come up with a formula that pulls out the largest currency value (i.e. the largest number preceded by a '£' sign. Any help you might have would be hugely appreciated.
As a note of caution, other cells might only have one currency value, so ideally the formula would look for all instances of '£XXX' and return the largest, or if there is only one instance simply return that.
I managed to put together a formula for cases with only one instance: =MID(B400,FIND("£",B400),FIND(" ",B400&" ",FIND("£",B400))-FIND("£",B400))+0 but cannot work out how to do it for the other cases.
Bookmarks