SUBSTITUTE and AND

Mar 12th, 2002, 07:56 AM

Hi all,

I'm trying to use =SUBSTITUTE and =AND in one formula but can't get the syntax right :

A1 : "This is the sentence I want to alter"

B1 : substitute "sentence" with "file" and substitute "alter" with "delete"

is it possible ?

many thanks
Chris

Dave Hawley · Mar 12th, 2002, 08:01 AM

Hi

If your text is in cell C3, try:

=SUBSTITUTE(SUBSTITUTE(C13,"sentence","File"),"alter","Delete")

Chris Davison · Mar 12th, 2002, 08:06 AM

Good on ya Dave !

thanks
Chris

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 07:56 AM	#1
Guest Posts: n/a	Hi all, I'm trying to use =SUBSTITUTE and =AND in one formula but can't get the syntax right : A1 : "This is the sentence I want to alter" B1 : substitute "sentence" with "file" and substitute "alter" with "delete" is it possible ? many thanks Chris

Mar 12th, 2002, 08:01 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi If your text is in cell C3, try: =SUBSTITUTE(SUBSTITUTE(C13,"sentence","File"),"alter","Delete")

Mar 12th, 2002, 08:06 AM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Good on ya Dave ! thanks Chris