Multiple values need to equal 1 value - Find and replace? Need help - Example in message

[henaghan]

[TABLE="width: 604"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Hi- I need help with finding and replacing different values to match 1 value.

For Example: I want the three lines below to = Benchmark Mexico[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]BENCHMARK – EL SALTO JAL MEX[/TD]
[/TR]
[TR]
[TD][TABLE="width: 604"]
<tbody>[TR]
[TD]BENCHMARK – TIJUANA MEXICO[/TD]
[/TR]
[TR]
[TD]BENCHMARK DE MEXICO - GUADALAJARA[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[AngieWilson]

not sure exactly what you're aimin for but a combination of Find, Trim and right functions might work.

 

[henaghan]

I want to create an alias for these so I can do a vlook up and say if you see these three lines, please match Benchmark Mexico, but I am trying to find an easy way to create the alias - I am working with 3K line items