Search and Remove Exact String

[Beaster]

I am having a little trouble figuring out how to find a string on one sheet and delete that exact string in another column on another sheet. The problem I'm having is say I want to delete D12, the script finds D12 in D120 and deletes the D12 part of D120 leaving just the 0. I only want to delete the string D12, and leave the string D120 alone. If I could get some help that would be great. Here is the code that I have. It searches on Sheet3, starting at A2 going down column A and finds the string located in column G in sheet 2.

Please Login or Register  to view this content.

[martindwilson]

what are the two similar strings?
you can often replace say d12{space} rather than just d12

[ragulduy]

I believe if you change
lookat:=xlpart
to
lookat:=xlwhole

that will do what you want.

[martindwilson]

not if the string is xxxx d12 yyyyyyyy and the other is wwwww d120 ggggggg nothing would get replaced

[ragulduy]

@Martin,

Wrongly or rightly, I took "that exact string" to mean, "D12" entered in a cell.

[Beaster]

I believe if you change
lookat:=xlpart
to
lookat:=xlwhole

that will do what you want.

Sorry I should have explained better. There will be multiple designators in the cells i'm looking in. So, the cell would include something like D12 D20 D3 etc...
So that command won't work bc whole looks at the whole cell value

[martindwilson]

did you try find d12[space] replace with [space]

[Beaster]

did you try find d12[space] replace with [space]

That worked thank you very much. I just realized I had that in my code before, but somehow it got taken out when I changed something. Thanks for the help.