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

[henaghan]

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

BENCHMARK – EL SALTO JAL MEX

BENCHMARK – TIJUANA MEXICO BENCHMARK DE MEXICO - GUADALAJARA <tbody> </tbody>

<colgroup><col></colgroup><tbody>
</tbody>

 

[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