Home

Column's alias in Query with Excel 365

%3CLINGO-SUB%20id%3D%22lingo-sub-833354%22%20slang%3D%22en-US%22%3EColumn's%20alias%20in%20Query%20with%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-833354%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EIn%20previous%20version%20of%20excel%20it%20was%20possible%20by%20modify%20registry%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F298955%2Fusing-a-field-alias-in-query-does-not-work-with-some%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F298955%2Fusing-a-field-alias-in-query-does-not-work-with-some%3C%2FA%3E...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EQuestion%20is%3A%20How%20to%20do%20it%20in%20excel%20365.%20I%20think%20about%20Query%20not%20Power%20Query.%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3EZiut%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-833354%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
jwozniak
New Contributor

Hi

In previous version of excel it was possible by modify registry:

https://support.microsoft.com/en-us/help/298955/using-a-field-alias-in-query-does-not-work-with-some...

 

Question is: How to do it in excel 365. I think about Query not Power Query.

Regards

Ziut

Related Conversations