The attached file contains two worksheets.
A script parses the information in worksheet "Original" into the information in worksheet "Results"
There are 2 requests:
1. Worksheet "Original" contains price information in column F and in column B. Example in cells B70 to B87 (and other cells below) shows price information that is incorrectly parsed to Column F in worksheets "Results".
The requirement is for the script to be amended so that all price information in column F and B, of the Original worksheet, is parsed to Column F in Results worksheet.
2. Worksheet "Original" contains the word with colon "Category:" as part of the information in column E.
The requirement is to have this word with colon "Category:" deleted from the worksheet "Results".