Results 1 to 5 of 5

Thread: Trim/Substitute but.. also, replace?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Sep 2018
    Posts
    132
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Trim/Substitute but.. also, replace?

    Situation is, I am using the following code to get some pretty specific text over from column A to column C.

    Code:
    =TRIM(SUBSTITUTE(A57,B57,""))
    The first 2 words are always equal to Network Bridge, followed by other text.

    My question is, is there a way to eliminate the space between the words network bridge within this formula without spreading over to another column?​ I know I can use the replace function, but then I'd have to spread over to column D which would not be desirable. Thank you kindly for all of your help!

  2. #2
    Board Regular
    Join Date
    Feb 2007
    Location
    England
    Posts
    3,704
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Trim/Substitute but.. also, replace?

    Can you provide a couple of examples of the before and after (desired) result?

    Matty

  3. #3
    Board Regular
    Join Date
    Sep 2018
    Posts
    132
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Trim/Substitute but.. also, replace?

    For instance, the output of the trim/substitute formula shown above is:

    Network Bridge 4.19 2.54 4.19 -1.48 6.83 4.58 8.39 8.42

    I would like the output to be:

    NetworkBridge 4.19 2.54 4.19 -1.48 6.83 4.58 8.39 8.42

    But, would somehow, like this code to accompany:

    Code:
    =TRIM(SUBSTITUTE(A57,B57,""))


  4. #4
    Board Regular
    Join Date
    Feb 2007
    Location
    England
    Posts
    3,704
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Trim/Substitute but.. also, replace?

    Unless I'm missing something, isn't this just:

    Code:
    =SUBSTITUTE(A1,"Network Bridge","NetworkBridge")
    Matty

  5. #5
    Board Regular
    Join Date
    Jun 2014
    Location
    Oakland, CA
    Posts
    5,146
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Trim/Substitute but.. also, replace?

    Hi,

    Use this:

    =SUBSTITUTE(TRIM(SUBSTITUTE(A57,B57,""))," ","",1)
    Last edited by jtakw; Feb 28th, 2019 at 04:28 PM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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