Extracting prices from a string of text [SOLVED] - Excel Help Forum
https://www.excelforum.com/excel-formulas-and-functions/1154856-extracting-prices-from-a-string-of-text.html
WEBSep 15, 2009 · "Asfsdfsdf (£30) - 3 x gfgdfgfdgfdgf, £4.50 dgfdgfdg"... Is it possible to extract the 2 prices (both preceded by "£"), add them together, and put the total in cell B1? (in this case resulting in £34.50 being displayed in cell B1) Issues that are making this formula tricky to work out as follows....
DA: 2 PA: 33 MOZ Rank: 33