clear cell contents based on conditions

I would like to clear any cell that only contains “?” and/or “,”.
Take a look at the image below:
1.JPG

From the image above we can see that in cell D4, E1, F2, F3 and F4 the contents consist of “?” and/or “,”, so I want my macro to detect such cells and clear its content.

Do not clear contents of cell that has together with “?” and/or “s” there may be other character. For e.g. from the above image if you look at cell D2 there is other words such as jp6_7, jp6_8, so such cells should not be cleared

I would like to do this to the entire column D, E and F

The final outcome should look like the image below
2.JPG

I have also attached a sample worksheet,
Book2.xls
Sheet 1 shows the initial texts
Sheet 2 contains a button where the macro should be written
Sheet 3 shows how the final outcome looks like

Why not just use the Find & Replace tool found in the EDIT dropdown of the toolbar, search for ? and replace with nothing.

Are there always numbers contained in cells that also contain ? that you want to keep?

Well as long as the cells that you want to keep will ALWAYS have at least one number in it this should work

Please Login or Register  to view this content.

Not tested as i dont have time

Please Login or Register  to view this content.

Like i said, i didnt have time to test it, thsi works or seems to work for me:

Please Login or Register  to view this content.