Changing Columns in PQ (Excel) question

[Mr_Phil]

Hi. I am a PQ rookie. If I have to change the name of a column is there a way to edit it all at once? I know in excel and vba I can do a control H and that gets me a find & replace dialog. But it doesn't seem to work in PQ editor.

If there isn't a way to do that, is there a way to export all the queries as a text file that I can put back after corrections are made?

Thanks in advance. I like it but the learning curve is steeper than I expected.

 

[alansidman]

If you are looking to find and replace in Column Headers, then the tutorial here should help. If it is something else, then post back with more details.