Hi,

I have the following text that needs to be changed:

Scenario 1
Original Text
Type-MHH Houston Terminal

Change To
MHH Type Houston Terminal

Scenario 2
Original Text
MHH Mall Type Houston

Change To
Mall Houston

Is there a formula that I could use to change the text ? The original list is very long and I need a formula to make the change. Is this possible ?

Appreciate all the help.

I have a cross post here:
http://www.mrexcel.com/forum/showthread.php?t=530381