Print

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:

Insert text anywhere in a cell without adding a new column using the Power Query User Interface.
Was this helpful?

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *

Table of Contents