Replace text in a string in Power Query

[srdavisgb]

The following is an example of text that appears in a header in the Power Query editor: 11/16/2023 Points Diff. The date is different in each cell. I would like to replace the cell value with just the date (e.g., drop the "Points Diff."). When I use Transform/Replace in the editor for "Points Diff." it says not found. Is How can you do this data clean-up in Power Query?

Thanks for you help!

 

[GraH]

You say it' s in the header.
Then you want to rename columns, not replace values.

 

[srdavisgb]

I am also unable to replace the value before it’s promoted to the header. There’s over 100 dates in this format. So, a search and replace all is most efficient. I don’t care where it’s done in the header row or before it’s made the header row. Any thoughts?

 

[zero269]

 

[srdavisgb]

Perfect! Thank you.

 

[smozgur]

Perfect! Thank you.

@srdavisgb: I just removed the solution mark from your own feedback post. Could you please mark the post that answered your question instead?