How to remove text from a column

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 👍

Follow me on Linkedin
Vote For my Idea💡