I have a string of text and there is either one or two dollar amounts within the text. I'd like to be able to pull those dollar amounts into another cell. The location within the cell varies and the dollar amounts vary. Example:
$125.95 a month, for a savings of $22.00 a month
and/or
Sales within a month is $130 a month for the month of January
Is there something that could find $ and pull the amounts in the next one and/or two cells?
Any help would be most appreciated. Thank you.
Bookmarks