I need help on how to create a formula to extract a certain data/string from a string.
Part Number
01,ABC123,PM012345,PONA,procars123,PMpp121
02,ABC111,DEF123,PM987654,PMXXX789,qt59,IN700,PM456
PM888999,XYZ007,ABCXYZ,PM12345678
...
...How do I extract strings that begins with 'PM' so that the report will look like:
Part Number
PM012345,PMpp121
PM987654,PMXXX789,PM456
PM888999,PM12345678
...
...Pls help
Thanks!