Search and replace between strings of placeholder text

nafets

New Member
Joined
Aug 17, 2017
Messages
1
Hi guys, how are you all?
encountered a big problem and now I am hoping you can help to solve it...
So basically to build a register for my book using indexmatic I need a list of the words looking kinda like this:
/(wierer)|(Albin Wierer)|(Wierer Albin)/ => Albin Wierer

The Names between the brackets beeing the the variations of the searched for word, the one after the arrow the final word that then gets shown in the index. Now my word list I have to build my index with looks something like this:
Basson;Basson;Berg;Tirol;0;0
Bescul;Bescul;Berg;Tirol;0;0
Borcolapass;Borcolapass;Berg;Tirol;0;0
Buolepass;Buolepass;Berg;Tirol;0;0
Cima di Mezzana;Cima di Mezzana;Berg;Tirol;0;0

And this continues so for about 650 lines.
So basically I have to automate it someway that I can individually replace the semicolons with different type of brackets (i can get rid of the zeros with a normal search and replace). Anyone here any clue how to do that sort of thing?

Cheers and have a good day (or night in my case).
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Forum statistics

Threads
1,223,214
Messages
6,170,774
Members
452,353
Latest member
strainu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top