Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-20-2016, 03:05 AM
Daniel Arbeit Daniel Arbeit is offline Delete cell content that has a specific format Windows 7 64bit Delete cell content that has a specific format Office 2010 64bit
Novice
Delete cell content that has a specific format
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete cell content that has a specific format 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 cell content that has a specific format Delete a row if a specific value exist on another sheet I_malc Excel Programming 1 10-06-2014 06:11 PM
Delete cell content that has a specific format 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft