Trim/Substitute but.. also, replace?

[srosk]

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

=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!

 

[Matty]

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

Matty

 

[srosk]

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:

[COLOR=#333333]=TRIM(SUBSTITUTE(A57,B57,""))[/COLOR]

 

[Matty]

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

=SUBSTITUTE(A1,"Network Bridge","NetworkBridge")

Matty

 

[jtakw]

Hi,

Use this:

=SUBSTITUTE(TRIM(SUBSTITUTE(A57,B57,""))," ","",1)