Batch Replace & rename Text in Column Headers (Public)

PHOTO EMBED

Wed Aug 11 2021 02:52:43 GMT+0000 (Coordinated Universal Time)

Saved by @cnewnham #vba

= Table.TransformColumnNames(#"Expanded Table Column1", each if Text.Contains(Text.Upper(_),"Old Text") then "New Text" & Text.Replace(Text.Upper(_),"Old Text","") else _)
content_copyCOPY

Insert as Custom Column #"Expanded Table Column1" must be name of previous step Can also insert by clicking insert step after

https://community.powerbi.com/t5/Desktop/Rename-column-headers-in-a-table/td-p/43801