Delete particular content from excel sheet with selected cells

82 Views Asked by At

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 .

enter image description here

1

There are 1 best solutions below

1
On BEST ANSWER

You can use the formula below in column O:

=SUBSTITUTE(N71,MID(N71,FIND(6, N71),3),"")