=SUBSTITUTE(C4,"~?#","") will this work to remove multiple string
in [Functions]
|
From: Raja Mahendiran S Raja Mahendiran on 10 May 2010 17:21 Hi All, I need to remove multiple string (special characters) in an excel field. Would the following work =SUBSTITUTE(C4,"~?#",""). I need to execte this without using Nest Function. Please help!!! Thank You
From: Bob Phillips on 10 May 2010 17:40 No, you need to nest them. -- HTH Bob "Raja Mahendiran S" <Raja Mahendiran S(a)discussions.microsoft.com> wrote in message news:9C16C750-3830-43F2-B1A6-4A46B37B3B9D(a)microsoft.com... > Hi All, > > I need to remove multiple string (special characters) in an excel field. > > Would the following work =SUBSTITUTE(C4,"~?#",""). I need to execte this > without using Nest Function. > > Please help!!! > > Thank You
From: Fred Smith on 10 May 2010 18:46 Nest not a function. It's just a description of putting one function within another. So what you need is: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C4,"#",""),"?",""),"~","") Regards, Fred "Raja Mahendiran S" <Raja Mahendiran S(a)discussions.microsoft.com> wrote in message news:9C16C750-3830-43F2-B1A6-4A46B37B3B9D(a)microsoft.com... > Hi All, > > I need to remove multiple string (special characters) in an excel field. > > Would the following work =SUBSTITUTE(C4,"~?#",""). I need to execte this > without using Nest Function. > > Please help!!! > > Thank You
|
Pages: 1 Prev: lookup to see if multiple values exist Next: Ranking from one sheet to another |