VBA ARRAY CODE HELP

[roykana]

Dear all master,
Please help for vba array code remove numbers based on specific contents of cell.

ORIIGINAL

RESULT

So remove the numbers based on the contents of the word "KANA".


Thanks

roykana

 

[Peter_SSs]

It's perfect and runs really fast.

Good news! Glad it worked for you.

May I ask for recommendations for links that can master vba array code and VBScript.

I learned just about everything I know about vba right here in the forum. ?
If looking for information specifically about regular expressions, I put a few links in this post recently but Googling should turn up a lot more resources.

 

[roykana]

Good news! Glad it worked for you.


I learned just about everything I know about vba right here in the forum. ?
If looking for information specifically about regular expressions, I put a few links in this post recently but Googling should turn up a lot more resources.

Thanks for the info and I will follow you. Thank you very much my teacher and master.