How to remove text from a column

[BRL7WZ]

Hello,

I would like to ask for your help.

The aim is to remove the word </div> from the URL address. 

</div>https://sites.share2.com/sites/Documents/Steuergeraetl.pdf</div>

I can't get over it

[DOLEARY85 · Accepted solution]

Hi,

you could do this simply in Power Query by right clicking the column, select replace values, then just enter </div> in the value to replace and leave the replace with field blank.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[BRL7WZ]

Hello,

worked perfectly. Thanks a lot!

Have a good day.

[Idrissshatila · Accepted solution]

Hello @BRL7WZ ,

In Power query under the transform tab, you click on extract then Text between two delimiters then you specifiy the delimiters, in your case they're </div>

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

[DOLEARY85 · Accepted solution]

Hi,

you could do this simply in Power Query by right clicking the column, select replace values, then just enter </div> in the value to replace and leave the replace with field blank.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍