Delete other values except "A" and "B" and "C"

[HerryMarkowitz]

Greetings,
I have following code in the enclosed file.

Please Login or Register  to view this content.

Open enclosed file and run Macro1 in order to understand what Macro1 is doing...

I need a macro which will do same operation of Macro1 but
delete other values except "A" and "B" and "C"
or
replace other values except "A" and "B" and "C" to nothing.

So, my aim is to shorten a Macro1.
Best wishes.

[ragulduy]

I reckon how you have it might be the quickest, the only way I could think of replacing everything except certain characters would be to loop through each character in the string and check it individually, or to use a formula to break the string into an array of characters and use a vba function to concatenate al the A's. B's and C's.

That said, if you are just interested in the length of your code as a character count:

Please Login or Register  to view this content.

is perhaps the same?

[HerryMarkowitz]

Hi yudlugar,
Thanks for the answer.
I need this code because cell characters could be other characters not only ">", "B", "p", "t".
So, I need a macro which will delete everything other than A, B and C.
Any other advice will be thankful...

[ragulduy]

Please Login or Register  to view this content.

[HerryMarkowitz]

I prefer regular code instead of function. If possible ?

[ragulduy]

Please Login or Register  to view this content.

[HerryMarkowitz]

Not solved.
But thanks anyway.