Find and replace for a number range in a long sentence.

[yoslater]

Question.

Here is my cell information. I know it is long and boring. I have about 600 products to edit and they all have different prices. I want to perform a Find and Replace. "Find 'Part Base= range of numbers and replace with Part Base=Price Match Guarantee. I know to perform this for a specific dollar amount ($18,192 in this example-Part Base=18,192) but not sure about a range from $0-$35,000. I hope this makes sense and my excel skills are low....

"Part Base=18,192";"Core Deposit= Refundable Core Deposit";"Applications=Bus, Ford Truck, Freightliner, PACCAR";Configuration=Drop-In;"On/Off Highway=On Highway";Displacement=7.2;Horsepower=200-300;Model=3126;"Model Years=1994-97";"Product Downloads=<a href=""/content/pdf/Product_Bulletin_CAT_3126.pdf"" target=""_blank"">Caterpillar 6 Cylinder 3126 and C7</a>"

 

[JamesCanale]

I'm not too sure this is what you would like. This will replace the first Part Base=..... up to the next " with the requested text. And lower is it all wrapped up in an incomprehensible formula.

MrExcelPlayground18.xlsx
	K
1	"Part Base=18,192";"Core Deposit= Refundable Core Deposit";"Applications=Bus, Ford Truck, Freightliner, PACCAR";Configuration=Drop-In;"On/Off Highway=On Highway";Displacement=7.2;Horsepower=200-300;Model=3126;"Model Years=1994-97";"Product Downloads=<a href=""/content/pdf/Product_Bulletin_CAT_3126.pdf"" target=""_blank"">Caterpillar 6 Cylinder 3126 and C7</a>"
2
3	"Part Base=Price Match Guarantee";"Core Deposit= Refundable Core Deposit";"Applications=Bus, Ford Truck, Freightliner, PACCAR";Configuration=Drop-In;"On/Off Highway=On Highway";Displacement=7.2;Horsepower=200-300;Model=3126;"Model Years=1994-97";"Product Downloads=<a href=""/content/pdf/Product_Bulletin_CAT_3126.pdf"" target=""_blank"">Caterpillar 6 Cylinder 3126 and C7</a>"
4
5	"Part Base=Price Match Guarantee";"Core Deposit= Refundable Core Deposit";"Applications=Bus, Ford Truck, Freightliner, PACCAR";Configuration=Drop-In;"On/Off Highway=On Highway";Displacement=7.2;Horsepower=200-300;Model=3126;"Model Years=1994-97";"Product Downloads=<a href=""/content/pdf/Product_Bulletin_CAT_3126.pdf"" target=""_blank"">Caterpillar 6 Cylinder 3126 and C7</a>"
Sheet1

Cell Formulas
Range	Formula
K3	K3	=LET(t,K1,a,SEARCH("Part Base=",t),b,SEARCH(CHAR(34),t,a+1),c,REPLACE(t,a,b-a,"Part Base=Price Match Guarantee"),c)
K5	K5	=REPLACE(K1,SEARCH("Part Base=",K1),SEARCH(CHAR(34),K1,SEARCH("Part Base=",K1)+1)-SEARCH("Part Base=",K1),"Part Base=Price Match Guarantee")

 

[yoslater]

I will try that, so is that a formula you applied to the row? or something else? apologize in advance for novice question.