Delete cell content that has a specific format

[Daniel Arbeit]

Hello,



as you can see in the Picture I have cells:
- empty
- only black
- only red
- black and red

Red is a correction, meaning if in a cell there are black in red characters it should delete the black characters, otherwise do nothing.

So I Need something like:
* run through all characters in a cell and check if there is a red one
* Count the number of red characters
* =RIGHT(current cell, number of red characters)

Maybe you have an idea how to realise the first two Points.

Thank you,
Daniel

[KunleExcel]

Dear Daniel,

Attached is the Code in Notepad to solve your problem. Make sure you have the first Cell in Column D selected before running the Code. I hope you know how to paste the Code into VBE.