I have a worksheet with multiple columns of data. Column "D" is basically a notes field. It has random notes, but also includes part numbers.
Column D Example:
Row 1: Customer needs new DS45678
Row 2: A new DS983 is needed by Wednesday.
What I need (want) to do is pull just the part numbers from "D" and copy them to "C".
Is there a way to write a formula that will find "DS" and copy that and all numbers after it until the first "white space" (Row 2 example) or end of data (Row 1 example)?
Example of what "C" should look like with the above example
Row 1: DS45678
Row 2: DS983
Thanks in advance.
Bookmarks