Insert text anywhere in a cell without adding a new column using the Power Query’s UI
There are no Insert functions ( that I know of) in the power query user interface, so if you don’t know M, you probably have to create a new column to insert text in power query.
In today’s video, I will show you how you can use power query user interface, to insert text into a column without adding a new column and using only one step.
*NOTE: this works for inserting text anywhere inside a record or value or cell.
Table of contents:
00:00 Intro & use case
00:35 Do it creating a new column
01:30 Do it again in one step
Watch the tutorial:

Was this helpful?
Reader Interactions