Delete particular content from excel sheet with selected cells

64 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 answers

1
AntoG On BEST ANSWER

You can use the formula below in column O:

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