#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Delete specific text | Jackson | Word VBA | 16 | 12-06-2019 08:24 PM |
Delete content next to a word. | Martinengo | Word | 5 | 01-28-2015 04:25 PM |
Delete a row if a specific value exist on another sheet | I_malc | Excel Programming | 1 | 10-06-2014 06:11 PM |
Cell Background Color: Base it on Content of Cell? | tatihulot | Excel | 4 | 08-14-2013 03:24 PM |
How can I delete the content of a cell in column if the cell value is more than 1000? | Learner7 | Excel | 2 | 06-27-2011 05:44 AM |