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

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.

Attached Files

DeleteContentBySpecificFormat.txt (930 Bytes, 11 views)