To Delete specific letters from the cells

[abduljaleel.mca]

Hi,

Below is my partial programming code

Please Login or Register  to view this content.

Using some condition I am getting the address of a cell. My program show a output of 'C' according to the data I have. Now I need to delete the char 'c' in all cells. The problem is below

my program works suppose if char 'c' appear as a single char in a cell.
It does not work in the combination of characters.

C -> It works
NC -> It does not work

Some programming modification needed in this line

Please Login or Register  to view this content.

Please help.

[watersev]

hi abduljaleel.mca, without clear understanding of the whole thing it is about, try this

Please Login or Register  to view this content.

[abduljaleel.mca]

Hi Watersev,

It is not working fine. I have attached a example file.

1. Please look at P6 it says 'O' and total 'O' column is blank. So I need to delete letter 'O'
2. Please look at N21 and Q21, these cells have letter 'O'. I can able to delete letter 'O' in N21 since it is a single character. But I can't able to delete the letter which is in Q21 as it is a combination of characters.
3. 2 letters (NO) is an example. It may be combination of many characters.

[watersev]

try this:

Please Login or Register  to view this content.

[abduljaleel.mca]

Thanks Watersev,
But it deletes all the characters from the cell Q21 i.e., it removes both N and O. It should remove only O and should leave char N (and other characters if present) as it is.

[watersev]

the line posted does not remove enything it checks if the specified letter(s) is(are) available in the cell. The cell content is deleted by Selection.ClearContents I suppose.
Example to remove all letters "O" from cell A1, A1= "NOAKJSO"

Please Login or Register  to view this content.

Result: A1= "NAKJS"
Amend to suit your needs

[abduljaleel.mca]

Hi watersev,

Thanks for your help, but still it is not working. It may work in your worksheet however it is not in my worksheet which I attached yesterday.

[watersev]

the attached file has no code of yours, what is the cell reference for total 'O' column?

[watersev]

if the total row is row 21 (basing on the posted file), this would delete "O" letter:

Please Login or Register  to view this content.

[abduljaleel.mca]

Hi Watersev,

I used your below code with some modifications in my code

Please Login or Register  to view this content.

Now I am getting my expected result, Thanks for your help.