Hey Guys!
I have a ton of listing titles for products I sell and I am trying to pull the part numbers out into a separate column. Is there a way to pull only the groups of words or parts numbers that contain a number? Please see example below:
240356406 - Sears Kenmore Refrigerator Door Bin Shelf Bucket White Replacement
Frigidaire Refrigerator Door Bin Shelf Bucket Clear AH430122 EA430122 891214
240356409 - Frigidaire Refrigerator Door Bin Shelf Bucket White Replacement
Sears Kenmore Refrigerator Door Bin Shelf Bucket White AH430121 EA430121 891213
240356402 - Frigidaire Refrigerator Door Bin Shelf Bucket Clear Replacement
240356414 - Sears Kenmore Refrigerator Door Bin Shelf Bucket Clear Replacement
I would like a separate column to pull out the following (because these sets of characters have numbers in them)
240356406
AH430122 EA430122 891214
240356409
AH430121 EA430121 891213
240356402
240356414
This would save me a ton of time. Thanks in advance for any assistance you can provide!
Bookmarks