pls use below formual.
=SUBSTITUTE(SUBSTITUTE(A1,"RUPEES ",""),"PAISAS ","")
From: mehtab shaikh
To: excel-macros@googlegroups.com
Sent: Saturday, August 31, 2013 12:59 PM
Subject: $$Excel-Macros$$ Formulae for Removing Certain Word from Sentance
Dear Ex
=SUBSTITUTE(SUBSTITUTE(A1,"Rupees",""),"PAISAS","")
see if it helps
On Sat, Aug 31, 2013 at 12:59 PM, mehtab shaikh wrote:
>
> Dear Experts,
>
> Please find enclosed example sheet and kindly advice formulae how to
> remove certain words from sentence.
>
>
>
> Best Regards,
>
> Mehtab
>
>
>
> -
