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