Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is it possible to include multiple substitions in a formula?

    Example:
    =SUBSTITUTE(A1,"SwapText_01","") or =SUBSTITUTE(A1,"SwapText_02","")


    Thanks,
    John

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Try this (I've highlighted the separate SUBSTITUTE functions:

    =SUBSTITUTE(SUBSTITUTE(A1,"SwapText_01",""),"SwapText_02","")

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by mbarron View Post
    Try this (I've highlighted the separate SUBSTITUTE functions:

    =SUBSTITUTE(SUBSTITUTE(A1,"SwapText_01",""),"SwapText_02","")
    Works perfectly.

    Thank you,
    John

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •