Deleting part of a string

[AndrewMac]

Hi all,

I have strings in each cell in Column A. In an array I have a substring of these strings. I want to replace the strings in column A with strings excluding the substrings in the array. Can anyone help?




Thanks in advance,

Andrew

[shg]

In an array I have a substring of these strings.

An array in code? If so, post it.

[FDibbins]

Im a little confused as to exactly what you want, but try using the substitute() function?

If that doesnt work for you, i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[AndrewMac]

My code is like this:

Please Login or Register  to view this content.

aZips (1) contains a substring that also is part of the string in Cell A2. At the end of the loopp I want the sString to be equal to sString without the substring in aZips(1)

I hope this is a little clearer.

Cheers,

Andrew

[FDibbins]

Next time, as per forum rules, please use code tags when posting VBA code (I added them for you - this time)

[shg]

Maybe instead

Please Login or Register  to view this content.