Forum Discussion
Solved
How to remove text from a column
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...
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 👍
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 👍
Hello,
worked perfectly. Thanks a lot!
Have a good day.