Nisarg Patel
Reputation: 39
Delete particular content from excel sheet with selected cells
I have stuck with one task as I need to delete particular content like "6" from selected cells which is given below screenshot as example for excel sheet .
Upvotes: 0
Views: 63
Answers (1)
AntoG
Reputation: 843
You can use the formula below in column O:
=SUBSTITUTE(N71,MID(N71,FIND(6, N71),3),"")
Upvotes: 2
Related Questions
- script to delete only content in an excel-worksheet
- Deleting values inside cells
- Delete specific content in Excel
- Delete cells from Excel via VBA
- Looking for specific contents in each of the cells in the column and delete the row in some cases
- delete content of particular Excel cells python
- Deleting Specific Cells Excel
- Delete all cells which contain specific information
- How can I delete every cell with a specific value in excel vba?
- Delete cells with a specific value