View Single Post
  #1   Report Post  
Esrei
 
Posts: n/a
Default Delete Right 5 if

I need a macro to do the following in B3:B500
If(right(......,5)="Total"
Delete Right(........,6)

Hope this is clear