Cell Merge with Text Amendment

[fish221171]

Hi Guys,

So glad I found this site, some very useful info on this forum. Great work...

I have a small issue I would like some help with please, hope someone can help.

I have the following example cells :
A B C
1 IT-555 Interface Eth0/1 IT-555_Eth0/1
2 IT-T43 Interface Eth1/1 IT-T43_Eth1/1
3 IT-211 Interface Eth0/0 IT-211_Eth0/0

Example : (A) has "IT-555" (B) has "Interface Eth0/1" and the result I want in C is "IT-555_Eth0/1"

So the end result I am trying to reach in column C is to merge the text from A & B and remove the word Interface and replace it with _

Can someone give me some help please.

Thank you in advance.

[Jonmo1]

Try

=SUBSTITUTE(A1&B1,"Interface ","_")

[FDibbins]

Hi and welcome to the forum

Thanks for the title change. Did you try Jonmo1's suggestion?

[fish221171]

Hi,

Yes and works great, but I also may need to amend this so it works with a VLOOKUP & SUBSTITUE, is that possible?

Thanks

[Jonmo1]

Probably, but you'll need to elaborate some more.

[fish221171]

Thanks for the reply but I think what you have suggested is working well for me, many thanks for your help. Great Forum.

[Jonmo1]

You're welcome.