How to remove variably placed text within a string of text by looking at the columns to the right

[jchunowitz]

Novice here. In a worksheet with 3,000 rows, one column includes cells that have a string of text that has many spaces, but includes PART COLOR, PART NAME, PART NUMBER, etc. The different inputs vary in number of spaces as well. I need to remove the part numbers which all appear in this format: "## ## ####." Unfortunately, the numbers are all different, but they are located on their own in a separate column next to the first column. Is there a formula that will direct Excel to remove the part numbers if they are found in the string of text? Please see my example below. The column on the right is how it should look once the part number is removed. Please let me know if you have a solution. Thanks!!!

 

[Alex Blakenburg]

Will this work for you ?

Book2
	A	B	C
1	Part No	Set Name	Cleansed Text
2	30 08 7190	This is in the text 30 08 7190 9999 555 yyyy zzz	This is in the text 9999 555 yyyy zzz
Sheet1

Cell Formulas
Range	Formula
C2	C2	=TRIM(SUBSTITUTE(B2,A2," "))