replace the symbols

[mechanix85]

Hello.
Tell me how to make character substitutions in the following example (I need to replace the symbol repeats listed in Table 2),

[v-ljerr-msft · Accepted solution]

Hi @mechanix85,

As you need to make multiple replacements of words in text between two tables, it's better to do the task in Power Query. Here is a good article about Using List.Generate() To Make Multiple Replacements Of Words In Text In Power Query for your reference. 

Regards

[mechanix85]

hi @v-ljerr-msft 

thank you very much for the link. On my example works, I will test on a working file

Good luck 😃

[Greg_Deckler]

Check out the SUBSTITUTE function:

https://msdn.microsoft.com/en-us/library/ee634233.aspx