researcherjake
New Member
- Joined
- Dec 20, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
- Mobile
- Web
Basically the title.
I'm trying to preserve the cell formatting from a regular Excel table into a Power Query table.
For example, cell A1 has the words "The Quick Brown Fox" and the only word "Brown" has been bolded. I would like to have that same word bolded in the Power Query table.
I know about "Change Type" and "Transform" in Power Query, but I don't see any other formatting options outside some Advanced Editor shenanigans'.
My m-code isn't the strongest, and my VBA skills are shaky at best, so there's a good chance I'm just missing something.
Are there any options?
See image for more examples
I'm trying to preserve the cell formatting from a regular Excel table into a Power Query table.
For example, cell A1 has the words "The Quick Brown Fox" and the only word "Brown" has been bolded. I would like to have that same word bolded in the Power Query table.
I know about "Change Type" and "Transform" in Power Query, but I don't see any other formatting options outside some Advanced Editor shenanigans'.
My m-code isn't the strongest, and my VBA skills are shaky at best, so there's a good chance I'm just missing something.
Are there any options?
See image for more examples