Dear All, I have a string contained in a single cell as below.
QuoteDisplay More150/50-PG Line
28.07.2016 05:44:48 By JOHN DOE
Report number:20160311-PIPE-01
Date:10-Mar-2016 – 30-Mar-2016
WORK REQUIRED
As found Defect/Problems:
1)50-PG-103-6101X (Item No. 140)
Some random report text here
Some random report text here
Some random report text here
As found Defect/Problems:
2)100-D-105-6101X (Item No. 168)
Some random report text here
Some random report text here
Some random report text here
As found Defect/Problems:
3)150-BD-101-6101X (Item No. 174)
Some random report text here
Some random report text here
Some random report text here
As found Defect/Problems:
4)150-PG-127-6101X (Item No. 175)
Some random report text here
Some random report text here
Some random report text here
As found Defect/Problems:
5)80-PG-142-61430 (Item No. 177)
Some random report text here
Some random report text here
Some random report text here
I need a way to extract the text 50-PG-103-6101X, 100-D-105-6101X, 150-BD-101-6101X, 150-PG-127-6101X and 80-PG-142-61430 into another cell. Preferably in this format.
50-PG-103-6101X
100-D-105-6101X
150-BD-101-6101X
150-PG-127-6101X
80-PG-142-61430
I tried searching all over the net, but none of the solution can do it ( or maybe I'm using the wrong search term). Hope you guys can point me at the right direction.