Look in the attached file first please. You will see the product names column. An example entry: ---- 9751 Reveal for E. coli O157:H7 20 Hour Complete System ??" contains 20 devices and 196.00 ----- media bottles for 20 tests. ----- Tasks 1. Spilt the number "9751" from the string and put it in a new column named "Product Code". This task affects all entries. 2. The number at the end of the entry is the price, in this example "196.00", split that into a new column named "Price". This task affects nearly all entries. 3. Sometimes the product name text is spread over 2 rows, I need that in 1 row. This task might have to be done manually, it affects about 100 entries, I think.
## Deliverables
the completed excel spreadsheet
## Platform
Excel 2003, Windows.