View Single Post
 
Old 06-20-2016, 03:05 AM
Daniel Arbeit Daniel Arbeit is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jun 2016
Posts: 5
Daniel Arbeit is on a distinguished road
Default Delete cell content that has a specific format

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

Reply With Quote