Remove Text String from Text String

[rockchalk33]

1	need 00001 help please-__-	need help please-__-
KXY247	with KXY247 this	with this
35	major 35 brain fart	major brain fart

Column A is showing a string of what I need removed from Column B with the final result being Column C. I have about 33000 rows this needs to run on wish me luck!

I feel this should be super simple but man am I struggling to find a solution!

Devin

 

[FormR]

Hi, here is one option. For this to work, with your first example, you would also need to include the leading zeros in column A.

Book1
	A	B	C
1	00001	need 00001 help please-__-	need help please-__-
2	KXY247	with KXY247 this	with this
3	35	major 35 brain fart	major brain fart
Sheet1

Cell Formulas
Range	Formula
C1:C3	C1	=TRIM(SUBSTITUTE(B1,A1,""))

 

[rockchalk33]

Hi, here is one option. For this to work, with your first example, you would also need to include the leading zeros in column A.

Book1
	A	B	C
1	00001	need 00001 help please-__-	need help please-__-
2	KXY247	with KXY247 this	with this
3	35	major 35 brain fart	major brain fart
Sheet1

Cell Formulas
Range	Formula
C1:C3	C1	=TRIM(SUBSTITUTE(B1,A1,""))

FormR,

Appreciate the help but there are multiple instances in this data where the leading zeros can range anywhere from zero to ten.

 

[rockchalk33]

Hi, here is one option. For this to work, with your first example, you would also need to include the leading zeros in column A.

Book1
	A	B	C
1	00001	need 00001 help please-__-	need help please-__-
2	KXY247	with KXY247 this	with this
3	35	major 35 brain fart	major brain fart
Sheet1

Cell Formulas
Range	Formula
C1:C3	C1	=TRIM(SUBSTITUTE(B1,A1,""))

There is also instances where something such as 1 would reappear later in the text string and I am needing just the first instance removed.

 

[shaowu459]

Will the string you want to replace always between the first and second blank?

 

[rockchalk33]

Will the string you want to replace always between the first and second blank?

shaowu459,

Unfortunately not...

 

[rockchalk33]

34	Wilson combat 34 extended ejector 45
35	Case 00035 stockman med folder chrome vanadium clip/spey/sheepfoot yellow hndl
35	Cci 0035 standard round nose (lrn)
35	Psp 035 belt slide iwb/owb med/lg

Here is actual data, we would want C1 to be "Wilson combat extended ejector 45", C2 to be "Case stockman med folder chrome vanadium clip/spey/sheepfoot yellow hndl", etc...

 

[shaowu459]

shaowu459,

Unfortunately not...

So you should add more sample data, including all situations as far as you know.

 

[shaowu459]

34	Wilson combat 34 extended ejector 45
35	Case 00035 stockman med folder chrome vanadium clip/spey/sheepfoot yellow hndl
35	Cci 0035 standard round nose (lrn)
35	Psp 035 belt slide iwb/owb med/lg

Here is actual data, we would want C1 to be "Wilson combat extended ejector 45", C2 to be "Case stockman med folder chrome vanadium clip/spey/sheepfoot yellow hndl", etc...

What's the version of Excel you are using?

 

[rockchalk33]

What's the version of Excel you are using?

365