• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to use Substitute Function

Casey Thomas

New Member
Ok I'm trying to substitute AMF and SFW text with "watauga/keller" and "Fort Worth."

Here's my formula, =SUBSTITUTE(A2,"amf","watauga/keller",1)

1st--It doesn't work
2nd--How do I add the substitute SFW for "Fort Worth" in the same formula?

Might seem easy but when I look up direction on websites it makes no sense to me.

Thanks!
Casey
 

Attachments

  • JR April 30th Update.xls
    16 KB · Views: 0
Hi Casey,
another one, similar to yours:

=SUBSTITUTE(SUBSTITUTE(A2,"AMF","watauga/keller"),"SFW","Fort Worth.")

Regards,
 
Back
Top